What should you examine to diagnose the cause of the to…

Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR
report:

What should you examine to diagnose the cause of the top three wait events?(Choose the
best answer.)

Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR
report:

What should you examine to diagnose the cause of the top three wait events?(Choose the
best answer.)

A.
theV$ACTIVE_SESSION_HISTORYview

B.
the Time Model Statistics section of the AWR report

C.
the SQL statements based on elapsed time from the AWR report

D.
the Latch Activity section

E.
the Segment Statistics section of the AWR report



Leave a Reply 8

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


dmx

dmx

Why B? Could you please explain. I think “E: the Segment Statistics section of the AWR report” is correct answer

job

job

A!

B doesnt make any sense.. you want to see what SQL, what blocks, what users etc are causing the problem.. not a time model for god sake

Fonx

Fonx

A is general
B is the usual way to read according to Oracle
C Would be mine because i am sure the sql will show which SQL and object causes the problem
D Would confirma latch is slow
E Would be my next stp after SQL

SO I would say C, may be E

robert

robert

E -the best answer
Segment Statistics section of AWR report icludes:
Segments by ITL Waits
Segments by Physical Reads
Segments by Logical ReadsSegments by Logical Reads
The combination of this statitistics can help as to diagnose top three wait events.