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?
Comments