You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The
Posted: Sun Jun 11, 2023 3:49 pm
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 informationYou 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
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