Purpose
gv$session_wait displays information about the current or last wait events of all sessions on all OBServer nodes, such as the event names and the amount of time spent on waiting.
Related tables/views
__all_virtual_session_event
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SID | bigint(20) | NO | The ID of the session. |
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| SVR_IP | varchar(32) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| EVENT | varchar(64) | NO | The name of the wait event. |
| P1TEXT | varchar(64) | NO | The description of the first parameter of the wait event. |
| P1 | bigint(20) unsigned | NO | The value of the first parameter of the wait event. |
| P2TEXT | varchar(64) | NO | The description of the second parameter of the wait event. |
| P2 | bigint(20) unsigned | NO | The value of the second parameter of the wait event. |
| P3TEXT | varchar(64) | NO | The description of the third parameter of the wait event. |
| P3 | bigint(20) unsigned | NO | The value of the third parameter 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 sequence number 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. |
| STATE | varchar(19) | NO | The state of the current wait event. Valid values: |
| WAIT_TIME_MICRO | bigint(20) | NO | The wait time in microseconds. It indicates the elapsed wait time if the session is in waiting state, and indicates the total wait time of the last wait if the session is not in the waiting state. |
| TIME_REMAINING_MICRO | bigint(20) | NO | |
| TIME_SINCE_LAST_WAIT_MICRO | bigint(20) | NO | The amount of time in microseconds elapsed since the end of the last wait. The value is 0 if the session is in Waiting state. |