1Z0-062 · Question #289
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…
The correct answer is B. running the Memory Advisor for the library cache. Repeated parsing activity of SQL statements indicates an issue with the library cache, as it stores parsed SQL statements; therefore, running the Memory Advisor specifically for the library cache will provide recommendations to address this.
Question
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?
Options
- Arunning the Memory Advisor for the buffer cache
- Brunning the Memory Advisor for the library cache
- Crunning the Memory Advisor for the SGA
- Drunning the Memory Advisor for the PGA
How the community answered
(28 responses)- B89% (25)
- C7% (2)
- D4% (1)
Why each option
Repeated parsing activity of SQL statements indicates an issue with the library cache, as it stores parsed SQL statements; therefore, running the Memory Advisor specifically for the library cache will provide recommendations to address this.
The buffer cache stores data blocks, and while important for performance, it does not directly address repeated SQL parsing activity.
The library cache stores parsed SQL statements and execution plans; repeated parsing activity indicates that SQL statements are not being found or retained, leading to performance issues. Running the Library Cache Advisor analyzes its usage and provides recommendations to optimize its size, directly addressing this problem.
Concept tested: Library cache advisor for parsing issues
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/using-memory-advisors.html#GUID-6D49138B-BA05-4BE7-B73C-2A41C9044955
Topics
Community Discussion
No community discussion yet for this question.