Oracle
1Z0-064 · Question #73
1Z0-064 Question #73: Real Exam Question with Answer & Explanation
The correct answer is B. The CPU is spending more time in finding cursors in the library cache. C. Cursors are not getting shared, resulting in a large number of hard parses. D. Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the. See the full explanation below for the reasoning.
Question
You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the AWR report: Which three statements are true in this scenario? (Choose three.)
Exhibit
Options
- ASessions are waiting for mutexes in share mode on cursors but other sessions are holding the
- BThe CPU is spending more time in finding cursors in the library cache.
- CCursors are not getting shared, resulting in a large number of hard parses.
- DSessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the
- EThe buffers required by queries are not found in the buffer cache, thereby increasing expensive
Community Discussion
No community discussion yet for this question.