V$SESSION_EVENT

This view displays information on waits for an event by a session.

Fields

The most relevant view fields are as follows:

• SID: The session identifier

• EVENT: The name of the wait event

• TOTAL_WAITS: The total number of waits for the event in the session

• TOTAL_TIMEOUTS: The total number of timeouts for the event in the session

• TIME_WAITED: The total amount of time waited, in hundredths of a second for the event in the session

• AVERAGE_WAIT: The average amount of time waited, in hundredths of a second for the event in the session

• MAX_WAIT: The maximum time waited, in hundredths of a second for the event in the session

• EVENT_ID: The wait event identifier

See also

• The V$SESSION and V$SESSTAT sections in this appendix