Overview
Displays the definitions of all wait events.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | Tenant ID |
| EVENT_ID | bigint(20) | NO | ID of the event to wait for |
| EVENT# | bigint(20) | NO | Index of the Waiting Event |
| NAME | varchar(64) | NO | Name of the event to wait for |
| DISPLAY_NAME | varchar(64) | NO | Alias for the wait event |
| PARAMETER1 | varchar(64) | NO | Parameter 1 of waitevent |
| PARAMETER2 | varchar(64) | NO | Parameter 2 of the WAIT FOR EVENT statement |
| PARAMETER3 | varchar(64) | NO | Parameter 3 of WAIT FOR EVENTS |
| WAIT_CLASS_ID | bigint(20) | NO | ID of the event type to wait for |
| WAIT_CALSS# | bigint(20) | NO | Index of the event type |
| WAIT_CLASS | varchar(64) | NO | Name of the event type being waited for |
Sample query
In the sys tenant, view the definitions of all pending events and display the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.V$EVENT_NAME limit 10;
The query result is as follows:
+--------+----------+--------+---------------------------+---------------------------+------------+------------+------------+---------------+-------------+------------+
| CON_ID | EVENT_ID | EVENT# | NAME | DISPLAY_NAME | PARAMETER1 | PARAMETER2 | PARAMETER3 | WAIT_CLASS_ID | WAIT_CLASS# | WAIT_CLASS |
+--------+----------+--------+---------------------------+---------------------------+------------+------------+------------+---------------+-------------+------------+
| 1 | 10000 | 0 | | | | | | 100 | 0 | OTHER |
| 1 | 10001 | 1 | db file data read | db file data read | fd | offset | size | 108 | 8 | USER_IO |
| 1 | 10002 | 2 | db file data `index read | db file data `index read | fd | offset | size | 108 | 8 | USER_IO |
| 1 | 11001 | 3 | db file compact read | db file compact read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1 | 11002 | 4 | db file compact write | db file compact write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1 | 11003 | 5 | db file index build read | db file index build read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1 | 11004 | 6 | db file index build write | db file index build write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1 | 11005 | 7 | db file migrate read | db file migrate read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1 | 11006 | 8 | db file migrate write | db file migrate write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1 | 11007 | 9 | bloomfilter build read | bloomfilter build read | fd | offset | size | 109 | 9 | SYSTEM_IO |
+--------+----------+--------+---------------------------+---------------------------+------------+------------+------------+---------------+-------------+------------+
10 rows in set
References
View the current or previous wait events for all sessions:
View all wait events at the session level:
View all tenant-level wait events:
For more information about wait events, see Common wait events.
For more information about statistical events, see Common statistical events.