Oracle OCP 1Z0 053 Q66(Automatic Shared Memory Management)

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: CE


1. 將SGA_TARGET設定為非零值，如果SHARED_POOL_SIZE也同時設定了非零，則表示SHARED_POOL_SIZE的最小值
2. 

Note:

The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.

參考：http://docs.oracle.com/cd/E18283_01/server.112/e17120/memory004.htm#BABGCBHI
        http://blog.csdn.net/jgmydsai/article/details/36880559

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2075469/，如需轉載，請註明出處，否則將追究法律責任。