Which two initialization parameters would you set to enable Automatic Shared Memory
Management? (Choose two.)
A.
set SHARED_POOL_SIZE to zero
B.
set STATISTICS_LEVEL to BASIC
C.
set SGA_TARGET to a non-zero value
D.
set DB_CACHE_SIZE to a non-zero value
E.
set STATISTICS_LEVEL to TYPICAL or ALL
Correct answers: C, E
I agree with you.
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm#i58728
Automatic Shared Memory Management simplifies the configuration of the SGA. To use Automatic Shared Memory Management, set the SGA_TARGET initialization parameter to a nonzero value and set the STATISTICS_LEVEL initialization parameter to TYPICAL or ALL.
Sybex OCP said:
To exercise control over the SGA, you’ll need to disable Automatic Memory Management and enable Automatic Shared Memory Management for the SGA by setting MEMORY_TARGET to zero and setting the values for SGA_MAX_SIZE and SGA_TARGET. You will also need to verify that the value of STATISTICS_LEVEL is set to TYPICAL or ALL.
Correct: C.E
Answer A could also be correct. Here’s why
See …
http://oracle.su/docs/11g/server.112/e10595/memory004.htm#BGBFDFJB
look for the section that says
You can take advantage of automatic shared memory management by setting Total SGA Size to 992M in Oracle Enterprise Manager, or by issuing the following statements:
ALTER SYSTEM SET SGA_TARGET = 992M;
ALTER SYSTEM SET SHARED_POOL_SIZE = 0;
ALTER SYSTEM SET LARGE_POOL_SIZE = 0;
ALTER SYSTEM SET JAVA_POOL_SIZE = 0;
ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS_POOL_SIZE = 0;
However as only 2 options are allowed I would say C and E.