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.
参考：http://docs.oracle.com/cd/E18283_01/server.112/e17120/memory004.htm#BABGCBHI
http://blog.csdn.net/jgmydsai/article/details/36880559
(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博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2075469/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
