Oracle
1Z0-064 · Question #50
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.)
The correct answer is E. the Segment Statistics section of the AWR report. See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- Athe V$ACTIVE_SESSION_HISTORY view
- Bthe Time Model Statistics section of the AWR report
- Cthe SQL statements based on elapsed time from the AWR report
- Dthe Latch Activity section
- Ethe Segment Statistics section of the AWR report
How the community answered
(56 responses)- A16% (9)
- B4% (2)
- C2% (1)
- D7% (4)
- E71% (40)
Community Discussion
No community discussion yet for this question.