1Z0-060 · Question #199
Examine the memory-related parameters of an Oracle database instance: Which statement is true?
The correct answer is B. PGA size can grow automatically beyond 500 MB. Under Automatic Memory Management (MEMORY_TARGET set), PGA_AGGREGATE_TARGET is a soft target, not a hard cap, so PGA can grow beyond 500 MB.
Question
Examine the memory-related parameters of an Oracle database instance:
Which statement is true?
Exhibit
Options
- AThe value of the memory_target parameter cannot be changed dynamically.
- BPGA size can grow automatically beyond 500 MB.
- COnly the components of SGA are managed automatically.
- DMemory is dynamically re-allocated between SGA and PGA as needed.
How the community answered
(30 responses)- A3% (1)
- B93% (28)
- C3% (1)
Why each option
Under Automatic Memory Management (MEMORY_TARGET set), PGA_AGGREGATE_TARGET is a soft target, not a hard cap, so PGA can grow beyond 500 MB.
MEMORY_TARGET is a dynamic parameter and can be altered with ALTER SYSTEM without restarting the database instance.
When MEMORY_TARGET is configured, Oracle enables Automatic Memory Management and treats PGA_AGGREGATE_TARGET as a tuning goal rather than an absolute ceiling. Oracle can allocate additional memory to PGA components beyond 500 MB by reclaiming it from SGA when workload demands require it, making the PGA effectively unbounded up to MEMORY_MAX_TARGET.
With MEMORY_TARGET enabled (AMM), both SGA components and PGA are managed automatically together - not SGA alone, which describes ASMM (SGA_TARGET without MEMORY_TARGET).
While dynamic reallocation between SGA and PGA does occur under AMM, this statement alone is less precisely correct in the context of the shown parameters than option B, which specifically addresses the PGA_AGGREGATE_TARGET boundary behavior.
Concept tested: Oracle Automatic Memory Management and PGA_AGGREGATE_TARGET as soft limit
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.
