1Z0-060 · Question #220
Examine these parameters for a database instance: Which two statement are true? (Choose two.)
The correct answer is B. The autotuned components of SGA are dynamically allocated. C. Only Automatic Shared Memory management (ASMM) is enabled. With SGA_TARGET set and MEMORY_TARGET at zero, only Automatic Shared Memory Management is active, meaning SGA sub-components are auto-tuned but the total SGA is capped by SGA_MAX_SIZE.
Question
Examine these parameters for a database instance:
Which two statement are true? (Choose two.)
Options
- ASGA can grow automatically beyond 4480 MB.
- BThe autotuned components of SGA are dynamically allocated.
- COnly Automatic Shared Memory management (ASMM) is enabled.
- DAutomatic Memory Management (AMM) and ASMM are enabled.
- EPGA can grow automatically beyond 1000 MB.
How the community answered
(23 responses)- A13% (3)
- B78% (18)
- D4% (1)
- E4% (1)
Why each option
With SGA_TARGET set and MEMORY_TARGET at zero, only Automatic Shared Memory Management is active, meaning SGA sub-components are auto-tuned but the total SGA is capped by SGA_MAX_SIZE.
SGA_MAX_SIZE is a hard ceiling; the SGA cannot grow beyond 4480 MB (or whatever SGA_MAX_SIZE is set to) even under ASMM because dynamic growth is bounded by that parameter.
When ASMM is enabled via SGA_TARGET, Oracle's memory advisor dynamically resizes autotuned components such as the buffer cache, shared pool, and large pool within the SGA_TARGET ceiling without requiring manual intervention.
AMM requires MEMORY_TARGET to be set to a nonzero value; because MEMORY_TARGET is 0, AMM is disabled and only ASMM - governed by SGA_TARGET - is active for this instance.
AMM requires both MEMORY_TARGET and optionally MEMORY_MAX_TARGET to be nonzero; with MEMORY_TARGET = 0, AMM is not enabled and only ASMM applies.
Under ASMM (not AMM), PGA sizing is still governed by PGA_AGGREGATE_TARGET rather than automatic memory management; the PGA does not grow automatically beyond its target in ASMM mode.
Concept tested: Automatic Shared Memory Management vs Automatic Memory Management parameters
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.