Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）

A、Run&ensp;the&ensp;SQL&ensp;Access&ensp;Advisor

B、Run&ensp;the&ensp;Memory&ensp;Advisor&ensp;for&ensp;the&ensp;sga.

C、Run&ensp;the&ensp;Memory&ensp;Advisor&ensp;for&ensp;the&ensp;pga.

D、Run&ensp;the&ensp;Memory&ensp;Advisor&ensp;for&ensp;the&ensp;shared&ensp;pool.

E、Run&ensp;the&ensp;Memory&ensp;Advisor&ensp;for&ensp;the&ensp;buffer&ensp;cache

问题详情

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）

答案解析