Note
This view is available starting with V1.4.
Purpose
This view displays the information of the most recent 10 wait events for all sessions in the current tenant across all OBServer nodes.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SID | bigint(20) | NO | For V4.2.x:
|
| CON_ID | bigint(20) | NO | The tenant ID. |
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| SEQ# | bigint(20) | NO | The sequence number of the wait event. |
| EVENT# | bigint(20) | NO | The number of the wait event. |
| EVENT | varchar(64) | NO | The name of the wait event. |
| P1TEXT | varchar(64) | NO | The description of parameter 1 of the wait event. |
| P1 | bigint(20) unsigned | NO | The value of parameter 1 of the wait event. |
| P2TEXT | varchar(64) | NO | The description of parameter 2 of the wait event. |
| P2 | bigint(20) unsigned | NO | The value of parameter 2 of the wait event. |
| P3TEXT | varchar(64) | NO | The description of parameter 3 of the wait event. |
| P3 | bigint(20) unsigned | NO | The value of parameter 3 of the wait event. |
| WAIT_TIME | double | NO | The wait time of the wait event, in hundredths of a second. |
| WAIT_TIME_MICRO | bigint(20) | NO | The wait time of the wait event, in microseconds. |
| TIME_SINCE_LAST_WAIT_MICRO | bigint(20) | NO | The time elapsed since the last wait ended, in microseconds. |
Sample query
Query the information of the most recent 10 wait events for all sessions in the current tenant across all OBServer nodes.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$SESSION_WAIT_HISTORY;
The query result is as follows:
+------------+--------+----------------+----------+------+--------+-------+--------+------+--------+------+--------+------+-------------------+------------------+----------------------------+
| SID | CON_ID | SVR_IP | SVR_PORT | SEQ# | EVENT# | EVENT | P1TEXT | P1 | P2TEXT | P2 | P3TEXT | P3 | WAIT_TIME | WAIT_TIME_MICRO | TIME_SINCE_LAST_WAIT_MICRO |
+------------+--------+----------------+----------+------+--------+-------+--------+------+--------+------+--------+------+-------------------+------------------+----------------------------+
| 3221661914 | 1002 | 11.xxx.xxx.xxx | 2882 | 1 | 0 | | | 0 | | 0 | | 0 | 174315142799.6285 | 1743151427996285 | 0 |
+------------+--------+----------------+----------+------+--------+-------+--------+------+--------+------+--------+------+-------------------+------------------+----------------------------+
1 row in set