Note
This view is introduced since OceanBase Database V1.4.
Purpose
The V$EVENT_NAME view displays the definitions of all wait events on the current OBServer node.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| EVENT_ID | bigint(20) | NO | The ID of the wait event. |
| EVENT# | bigint(20) | NO | The subscript of the wait event. |
| NAME | varchar(64) | NO | The name of the wait event. |
| DISPLAY_NAME | varchar(64) | NO | The alias of the wait event. |
| PARAMETER1 | varchar(64) | NO | The first parameter of the wait event. |
| PARAMETER2 | varchar(64) | NO | The second parameter of the wait event. |
| PARAMETER3 | varchar(64) | NO | 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_CALSS# | bigint(20) | NO | The subscript 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. |
Sample query
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 |
+--------+----------+--------+---------------------------+---------------------------+------------+------------+------------+---------------+-------------+------------+
| 1002 | 10000 | 0 | | | | | | 100 | 0 | OTHER |
| 1002 | 10001 | 1 | db file data read | db file data read | fd | offset | size | 108 | 8 | USER_IO |
| 1002 | 10002 | 2 | db file data `index read | db file data `index read | fd | offset | size | 108 | 8 | USER_IO |
| 1002 | 11001 | 3 | db file compact read | db file compact read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1002 | 11002 | 4 | db file compact write | db file compact write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1002 | 11003 | 5 | db file index build read | db file index build read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1002 | 11004 | 6 | db file index build write | db file index build write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1002 | 11005 | 7 | db file migrate read | db file migrate read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1002 | 11006 | 8 | db file migrate write | db file migrate write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1002 | 11007 | 9 | bloomfilter build read | bloomfilter build read | fd | offset | size | 109 | 9 | SYSTEM_IO |
+--------+----------+--------+---------------------------+---------------------------+------------+------------+------------+---------------+-------------+------------+
10 rows in set (0.012 sec)