What should you examine to diagnose the cause of the top three wait events?

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. the V$ACTIVE_SESSION_HISTORY view
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

Download Printable PDF. VALID exam to help you PASS.

One thought on “What should you examine to diagnose the cause of the top three wait events?

  1. E is the right answer. Segment Statistics section contains Segments by ITL Waits

    E. the Segment Statistics section of the AWR report

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.