1Z0-062 · Question #239
You set the following parameters in the parameter file and restart the database instance: Which two statements are true?
The correct answer is A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. C. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.. If MEMORY_TARGET is set to a non-zero value, MEMORY_MAX_TARGET is automatically adjusted to match it, but if both are unset or zero, AMM is disabled and MEMORY_MAX_TARGET remains zero.
Question
You set the following parameters in the parameter file and restart the database instance:
Which two statements are true?
Options
- AThe MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
- BThe PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to
- CThe value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.
- DThe lower limits of thePGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to
- EThe instance does not start up because Automatic Memory Management (AMM) is enabled but
How the community answered
(28 responses)- A79% (22)
- B4% (1)
- D4% (1)
- E14% (4)
Why each option
If `MEMORY_TARGET` is set to a non-zero value, `MEMORY_MAX_TARGET` is automatically adjusted to match it, but if both are unset or zero, AMM is disabled and `MEMORY_MAX_TARGET` remains zero.
If `MEMORY_TARGET` is configured to 500 MB and `MEMORY_MAX_TARGET` is not explicitly set in the parameter file, Oracle automatically sets `MEMORY_MAX_TARGET` to match `MEMORY_TARGET` during instance startup.
`PGA_AGGREGATE_TARGET` and `SGA_TARGET` are typically set when AMM is not fully enabled and are not automatically set to 0 when AMM is in use unless specifically configured as such.
If `MEMORY_TARGET` is not set or set to 0, and `MEMORY_MAX_TARGET` is also not set or set to 0, Automatic Memory Management (AMM) is disabled, and the `MEMORY_MAX_TARGET` value effectively remains zero for the instance.
`PGA_AGGREGATE_TARGET` and `SGA_TARGET` define memory targets, not lower limits, for their respective areas when AMM is not fully enabled.
The instance will start up, as setting `MEMORY_TARGET` enables AMM, and if `MEMORY_MAX_TARGET` is not explicitly set or set to 0, it defaults to `MEMORY_TARGET` value, which does not prevent startup.
Concept tested: Oracle Automatic Memory Management (AMM) parameters
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-E53B0282-3B45-4299-8D7E-D96F3430A370
Topics
Community Discussion
No community discussion yet for this question.