Oracle Database 12c: Installation and Administration — Question 13

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?

Answer options

• A. running the Memory Advisor for the buffer cache
• B. running the Memory Advisor for the library cache
• C. running the Memory Advisor for the SGA
• D. running the Memory Advisor for the PGA

Correct answer: B

Explanation

The correct answer is B because the library cache is responsible for storing parsed SQL statements and execution plans. By running the Memory Advisor for the library cache, you can identify and resolve issues related to repeated parsing, while the other options target different memory components that do not directly impact SQL parsing performance.