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.)
- A: Sessions are waiting for mutexes in share mode on cursors but other sessions are holding the mutexes in exclusive mode.
- 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 mutexes in share mode.
- E: The buffers required by queries are not found in the buffer cache, thereby increasing expensive disk I/O.