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

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
degraation 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.
答案：D
解析：题目说asmm禁用了，由于sql语句反复的解析使得执行效率比较低，导致整体性能降低，应该怎么做
sql语句执行的过程是，编译-执行-提取数据，其中编译的时候在共享池的库高速缓冲查找是否有相同的sql，如果
没有就进行编译，编译后放入共享的sql区，题目中说的也就是第一步，也就是shared pool，因此选择D