OCP 1Z0 053 66

66.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 
Answer: AC 


答案应该是 C E
SHARED_POOL_SIZE 设置为非0，只能表示最小值。不影响 Aotomatic

Setting SGA Target Size

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.