OCP-1Z0-052-V8.02-56题

56. View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings,

respectively. 

Why are advisors not available for the shared pool and the buffer cache?

A.because the DB_CACHE_ADVICE parameter is set to OFF

B.because Automatic Memory Management (AMM) is disabled for the database instance

C.because Automatic Shared Memory Management (ASMM) is enabled for the database instance

D.because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set

initially

Answer: C  

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12561191

从图中各参数的值看出，Memory_target设置了非零值，意味着启用了AMM自动内存管理，AMM启用后，ASMM也会被启用，从图中也可以看出， automatic shared memory management是enabled的。

ASMM被启用后，SGA内的各个组件是动态分配的。故在shared pool和buffer cache后面没有advise。