why the instance failed to start the first time?

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?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Rodrigo

Rodrigo

Doc ID 461100.1


CAUSE

If the STATISTICS_LEVEL=BASIC during startup while SGA_TARGET is set 0 , you will see this error.

L. Zhu

L. Zhu

STATISTICS_LEVEL=BASIC is not compatible with MEMORY_TARGET (AMM) and SGA_TARGET (ASMM)

So A is right