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

57. Automatic Shared Memory Management is disabled for your database instance. You realize that there

are cases of SQL statements performing poorly because of repeated parsing activity, resulting in

degradation of performance.

What would be your next step to improve performance?

A.Run the SQL Access Advisor.

B.Run the Memory Advisor for the SGA.

C.Run the Memory Advisor for the PGA.

D.Run the Memory Advisor for the shared pool.

E.Run the Memory Advisor for the buffer cache.

Answer: D  

答案解析：

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

题意说在ASMM禁用的情况下，sql运行语句情况不好，有很多重复的解析导致性能下降。sql是在共享池运行并解析的。

出现上述情况，原因是共享池的SHARED_POOL_SIZE参数设置太小，建议是执行内存指导来重新设置SHARED_POOL_SIZE参数的值。