Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two)
A.
set LOG_BUFFER to zero
B.
set SHARED_POOL_SIZE to zero
C.
set DB_CACHE_SIZE to a non-zero value
D.
set STATISTICS_LEVEL to BASIC
E.
set SGA_TARGET to a non-zero value
F.
set STATISTICS_LEVEL to TYPICAL or ALL
Explanation:
The ASMM is driven by one init parameter: SGA_TARGET.When set to 0, the ASMM is disabled and you run with the old method, so you need to define the above auto-tuned parameters by yourself. The default value for SGA_TARGET is 0 so ASMM disabled.
The conditions to enable the ASMM mechanism are:
STATISTICS_LEVEL=TYPICAL or ALL
SGA_TARGET > 0
When you use a value greater than 0, the ASMM is enabled and the memory will be spread between all components: auto-tuned and manual parameters. The SGA_TARGET value will therefore define the memory size sharable between auto-tuned and manual parameters.
REF.: Metalink Note: 295626.1How To Use Automatic Shared Memory Management (ASMM) In Oracle10g
Correct answer is E and F
http://docs.oracle.com/cd/E18283_01/server.112/e17120/memory004.htm#i1014121
———————————–
You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to a nonzero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamically resized (tuned) as needed.
Note:
The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.
I choose EF