You are administering a database that supports a mixed workload.
TheCURSOR_SHARINGparameter is set to the default value. While analyzing the latest
Automatic Workload Repository (AWR) report, you find a large number ofcursor: pin S
wait on X, cursor: pin X wait on S, andlibrary cache mutexwaits 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 cursorsbut 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.
A – right and D – wrong
https://docs.oracle.com/database/121/REFRN/GUID-6230F000-F5E2-4589-BD2E-E2B0686D901D.htm#REFRN00525
E – wrong since Buffer Hit is 99.95%
B,C – right
B – right since %Non-Parce CPU is 70.94% which means only 70% of cpu time is utilized for execution
C – right as Execute to parse is 47% meaning that about half queries resulted in hard parsing
I agree with you about C. 52.72% of soft parse does not make “a large number of hard parse”
A,C,D
A,B,C
A,C,D
imo:
A: true
B: the question is a bit confusing. More time THAN WHAT ?
Not Parse CPU means it does not take a long time to parse
C: true. 52,72% of soft parse => 47.23% of hard parse, which is too much.
D: strategically, i would say that A & D are exclusive. So A or D, but not both.
E: wrong because buffer hit is very high
So I would say A, B, C