Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

• A.?Run the SQL Access Advisor.
• B.?Run the Memory Advisor for the shared pool.
• C.?Run the SQL Tuning Advisor.
• D.?Run the Memory Advisor for the Program Global Area.
• E.?Run the Memory Advisor for the System Global Area.

?

B

?

?

https://blogs.oracle.com/oraclemagazine/using-database-advisors

The shared pool advisor provides information about the estimated parse time in the shared pool for different pool sizes, the buffer cache advisor provides information about physical reads and time for the cache size, and the PGA advisor provides information about cache hit percentage against PGA target memory size.