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
Explanation:
Using the Memory Advisor through OEM
The Memory Advisor can be used only when the automatic memory management (AMM) feature
is disabled. The Memory Advisor has three advisors that give recommendations on: the Shared
Pool in the SGA, the Buffer Cache in the SGA, and the PGA.
Parsed SQL Statements are stored in Shared SQL Area which are in shared pool.
refer to this link
http://docs.oracle.com/cd/E15586_01/server.1111/e25789/memory.htm#i10223