当数据库实例禁用了自动共享内存管理(ASMM)，SQL语句因重复解析活动导致性能下降。解决方法是运行共享池内存顾问，调整SHARED_POOL_SIZE参数，提升SQL执行效率。
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参数的值。
再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
