Oracle Database Administration II — Question 24

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because running the Memory Advisor for the shared pool helps identify memory usage and can optimize performance by addressing hard parsing issues. The other options focus on different areas, such as SQL Access or Tuning Advisors, which may not directly resolve the shared memory management problems impacting performance.