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

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial