This view displays information on waits for an event by a session.
The most relevant view fields are as follows:
SID
: The session identifierEVENT
: The name of the wait eventTOTAL_WAITS
: The total number of waits for the event in the sessionTOTAL_TIMEOUTS
: The total number of timeouts for the event in the sessionTIME_WAITED
: The total amount of time waited, in hundredths of a second for the event in the sessionAVERAGE_WAIT
: The average amount of time waited, in hundredths of a second for the event in the sessionMAX_WAIT
: The maximum time waited, in hundredths of a second for the event in the sessionEVENT_ID
: The wait event identifier