V$SYSTEM_EVENT
This view displays information on total waits for an event.
Fields
The most relevant view fields are as follows:
EVENT
: The name of the wait eventEVENT_ID
: The identifier of the wait eventTOTAL_WAITS
: The total number of waits for the eventTIME_WAITED
: The total amount of time waited in hundredths of a second for the eventAVERAGE_WAIT
: The average amount of time waited in hundredths of a second for the eventTOTAL_TIMEOUTS
: The total number of timeouts for the event