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?
A.
because the STATISTICS_LEVEL parameter was set to BASIC
B.
because the PGA_AGGREGATE_TARGET parameter was set to zero
C.
because both the SGA_TARGET and MEMORY_TARGET parameters were set
D.
because MEMORY_TARGET and MEMORY_MAX_TARGET parameters were equal
E.
because the PROCESSES parameter was set to a value less than the minimum required
Doc ID 461100.1
…
CAUSE
If the STATISTICS_LEVEL=BASIC during startup while SGA_TARGET is set 0 , you will see this error.
…
STATISTICS_LEVEL=BASIC is not compatible with MEMORY_TARGET (AMM) and SGA_TARGET (ASMM)
So A is right