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

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 2

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


Amit Gupta

Amit Gupta

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.

mr_tienvu

mr_tienvu

I choose EF