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.