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
agree, B
B
Why B? Could you please explain. I think “E: the Segment Statistics section of the AWR report” is correct answer
Must B!
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
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
C –
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.