053-416

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters? (Choose all that apply.)
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE

   Each of these are SGA components that are configured manually if you choose not manage the SGA using Automatic Shared Memory Management or all memory using Atuomatic Memory Management.The SGA_MAX_SIZE is not an SGA component but represents the maximum value for the combined SGA pool sizes.The SORT_AREA_SIZE is a manual PGA initialization parameter. 

posted @ 2017-11-14 14:05  巴啦啦大魔王  阅读(127)  评论(0编辑  收藏  举报