1Z0-054 · Question #101
You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The following are the some of the parameter settings: MEMORY_MAX_TARGET=600M…
The correct answer is A. because the STATISTICS_LEVEL parameter was set to BASIC. See the full explanation below for the reasoning.
Question
You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The following are the some of the parameter settings:
MEMORY_MAX_TARGET=600M SGA_MAX_SIZE=500M MEMORY_TARGET=600M OPEN_CURSORS=300 SGA_TARGET=300M PROCESSES=150 STATASTICS_LEVEL=BASIC PGA_AGGREGATE_TARGET=0 When you tried to start the database instance with these parameter settings, you received the following error:
SQL> startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information You modified the parameter settings as shown below and the database instance started successfully. MEMORY_MAX_TARGET=600M SGA_MAX_SIZE=400M MEMORY_TARGET=550M OPEN_CURSORS=400 SGA_TARGET=300M PROCESSES=200 STATASTICS_LEVEL=TYPICAL PGA_AGGREGATE_TARGET=100M Analyze the parameter settings and identify why the instance failed to start the first time?
Options
- Abecause the STATISTICS_LEVEL parameter was set to BASIC
- Bbecause the PGA_AGGREGATE_TARGET parameter was set to zero
- Cbecause both the SGA_TARGET and MEMORY_TARGET parameters were set
- Dbecause MEMORY_TARGET and MEMORY_MAX_TARGET parameters were equal
- Ebecause the PROCESSES parameter was set to a value less than the minimum required
How the community answered
(39 responses)- A77% (30)
- B5% (2)
- C13% (5)
- D3% (1)
- E3% (1)
Community Discussion
No community discussion yet for this question.