Feature
This view displays detailed information about the current wait events in each session. Each wait event has three parameters.
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(46) | NO | The IP address of the OBServer. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer. |
| EVENT | varchar(64) | NO | The name of the 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. |