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