Oracle 11G OCP 1Z0-052 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.

答案：（D）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1180138/，如需轉載，請註明出處，否則將追究法律責任。