1Z0-052 · Question #44
You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true about…
The correct answer is A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90. When MEMORY_TARGET is set and MEMORY_MAX_TARGET is 0, Oracle automatically raises MEMORY_MAX_TARGET to match MEMORY_TARGET, and PGA_AGGREGATE_TARGET and SGA_TARGET act as minimum floor values under Automatic Memory Management.
Question
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted? (Choose two.)
Options
- AThe MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
- BThe PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
- CThe value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
- DThe lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90
How the community answered
(24 responses)- A63% (15)
- B13% (3)
- C25% (6)
Why each option
When MEMORY_TARGET is set and MEMORY_MAX_TARGET is 0, Oracle automatically raises MEMORY_MAX_TARGET to match MEMORY_TARGET, and PGA_AGGREGATE_TARGET and SGA_TARGET act as minimum floor values under Automatic Memory Management.
Oracle automatically sets MEMORY_MAX_TARGET equal to the value of MEMORY_TARGET (500M) when MEMORY_MAX_TARGET is initialized to 0, because MEMORY_TARGET cannot exceed MEMORY_MAX_TARGET and the database adjusts the ceiling accordingly.
When MEMORY_TARGET is set, PGA_AGGREGATE_TARGET and SGA_TARGET are not zeroed out; they are retained as minimum floor values that constrain how low Oracle's automatic tuning can reduce each memory area.
MEMORY_MAX_TARGET is not left at zero; Oracle automatically adjusts it upward to equal MEMORY_TARGET at instance startup when the parameter file specifies MEMORY_MAX_TARGET=0 alongside a nonzero MEMORY_TARGET.
Under Automatic Memory Management, non-zero values for PGA_AGGREGATE_TARGET and SGA_TARGET serve as lower bounds - Oracle will not shrink PGA below 90M or SGA below 270M while dynamically tuning memory distribution within the MEMORY_TARGET envelope.
Concept tested: Oracle Automatic Memory Management parameter interaction
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html
Topics
Community Discussion
No community discussion yet for this question.