Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two)

Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *