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
Setting STATISTICS_LEVEL to BASIC disables many important statistics required for Oracle features and functionality, specifically including “Automatic SGA Memory Management”:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm