Which three statements are true in this scenario?

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.)

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.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


vasya

vasya

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

Jonesy

Jonesy

I agree with you about C. 52.72% of soft parse does not make “a large number of hard parse”

Jonesy

Jonesy

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