1Z0-064 · Question #73
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…
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
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
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.