OCP CBT Question 544

Please solve the following question.

You are managing an Oracle 19c database where Automatic Memory Management (AMM) is enabled. You observe high pga_in_mem_size and pga_used_size in V$PGASTAT and occasional "out of memory" errors for large sorts. You check the memory parameters:You also notice that the operating system has 32GB of physical RAM. What is the most effective approach to mitigate the "out of memory" errors for PGA while ensuring overall memory stability?

Current Memory Parameters`sqlSHOW PARAMETER memory_target;-- memory_target = 20GSHOW PARAMETER memory_max_target;-- memory_max_target = 25GSHOW PARAMETER sga_target;-- sga_target = 0 (default, meaning AMM manages it)SHOW PARAMETER pga_aggregate_target;-- pga_aggregate_target = 0 (default, meaning AMM manages it)`Assume the _AM_MEM_USE_THRESHOLD hidden parameter is at its default value (90%).

Increase MEMORY_TARGET to 25G. This will provide more memory for both SGA and PGA.

Increase pga_aggregate_target to a specific value (e.g., 8G), leaving sga_target at 0. This will ensure PGA gets a guaranteed minimum.

Disable AMM by setting MEMORY_TARGET=0 and manually configure SGA_TARGET and PGA_AGGREGATE_TARGET with specific values, ensuring PGA_AGGREGATE_TARGET is sufficiently large.

Decrease MEMORY_TARGET to allow the OS more free memory, which might help specific PGA allocations.