Purpose
V$SESSION_WAIT displays information about the current or last wait event of all sessions on the current OBServer node, including the name and duration of the wait event.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SID | NUMBER(38) | NO | The ID of the session. |
| CON_ID | NUMBER(38) | NO | The ID of the tenant. |
| EVENT | NUMBER(38) | NO | The name of the wait event. |
| P1TEXT | VARCHAR2(64) | NO | The description of the first parameter of the wait event. |
| P1 | NUMBER(38) | NO | The value of the first parameter of the wait event. |
| P2TEXT | VARCHAR2(64) | NO | The description of the second parameter of the wait event. |
| P2 | NUMBER(38) | NO | The value of the second parameter of the wait event. |
| P3TEXT | VARCHAR2(64) | NO | The description of the third parameter of the wait event. |
| P3 | NUMBER(38) | NO | The value of the third parameter of the wait event. |
| WAIT_CLASS_ID | NUMBER(38) | NO | The ID of the class to which the wait event belongs. |
| WAIT_CLASS# | NUMBER(38) | NO | The sequence number of the class to which the wait event belongs. |
| WAIT_CLASS | VARCHAR2(64) | NO | The name of the class to which the wait event belongs. |
| STATE | VARCHAR2(19) | NO | The state of the current wait event. Valid values: |
| WAIT_TIME_MICRO | NUMBER(38) | NO | The wait time, in microseconds. If the session is in the Waiting state, it indicates the elapsed wait time. If the session is not in the Waiting state, it indicates the total wait time of the last wait. |
| TIME_REMAINING_MICRO | NUMBER(38) | NO | |
| TIME_SINCE_LAST_WAIT_MICRO | NUMBER(38) | NO | The time elapsed since the end of the last wait, in microseconds. The value is 0 if the session is in the Waiting state. |