Overview
v$session_event displays information about wait events in each session.
Related tables/views
gv$session_event
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| SID | BIGINT(20) | No | The ID of the session. |
| CON_ID | BIGINT(20) | No | The ID of the tenant. |
| EVENT_ID | BIGINT(20) | No | The ID of the wait event. |
| EVENT | varchar(64) | No | The description of the wait event. |
| WAIT_CLASS_ID | BIGINT(20) | No | The ID of the class to which the wait event belongs. |
| WAIT_CLASS# | BIGINT(20) | No | The subscript of the class to which the wait event belongs. |
| WAIT_CLASS | varchar(64) | No | The name of the class to which the wait event belongs. |
| TOTAL_WAITS | BIGINT(20) | No | The total number of waits for the event. |
| TOTAL_TIMEOUTS | BIGINT(20) | No | The total number of wait timeouts for the event. |
| TIME_WAITED | DOUBLE | No | The total wait time for the event, in hundredths of a second. |
| MAX_WAIT | DOUBLE | No | The longest wait time for the event, in hundredths of a second. |
| AVERAGE_WAIT | DOUBLE | No | The average wait time for the event, in hundredths of a second. |
| TIME_WAITED_MICRO | BIGINT(20) | No | The total wait time for the event in microseconds. |