Purpose
GV$SESSION_WAIT displays information about the current or last wait event of all sessions on all OBServer nodes, such as the wait event name and duration.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SID | NUMBER(38) | NO | The ID of the session. |
| CON_ID | NUMBER(38) | NO | The ID of the tenant. |
| SVR_IP | VARCHAR2(32) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| EVENT | VARCHAR2(64) | 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: timed_statistics parameter is set to false. In other words, a wait event has occurred but lasted only for a very short period of time. |
| WAIT_TIME_MICRO | NUMBER(38) | NO | The wait time, in microseconds. If the session is waiting, it indicates the duration of the waiting time. If it is not waiting, it indicates the total waiting time of the last wait. |
| TIME_REMAINING_MICRO | NUMBER(38) | NO | |
| TIME_SINCE_LAST_WAIT_MICRO | NUMBER(38) | NO | The time elapsed from the end of the last wait until now, in microseconds. If the session is waiting, the value is 0. |