You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply