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 | NUMBER | NO | The ID of the tenant. |
| EVENT_ID | NUMBER | NO | The ID of the wait event. |
| EVENT# | NUMBER | NO | The number of the wait event. |
| NAME | VARCHAR2(64) | NO | The name of the wait event. |
| DISPLAY_NAME | VARCHAR2(64) | NO | The displayed name of the wait event. |
| PARAMETER1 | VARCHAR2(64) | NO | The first parameter of the wait event. |
| PARAMETER2 | VARCHAR2(64) | NO | The second parameter of the wait event. |
| PARAMETER3 | VARCHAR2(64) | NO | The third parameter of the wait event. |
| WAIT_CLASS_ID | NUMBER | NO | The ID of the class to which the wait event belongs. |
| WAIT_CLASS# | NUMBER | NO | The subscript of the class to which the wait event belongs. |
| WAIT_CLASS | VARCHAR2(64) | NO | The name of the class to which the wait event belongs. |
Sample query
obclient [SYS]> SELECT * FROM SYS.V$EVENT_NAME WHERE ROWNUM <= 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 |
+--------+----------+--------+---------------------------+---------------------------+------------+------------+------------+---------------+-------------+------------+
| 1004 | 10000 | 0 | NULL | NULL | NULL | NULL | NULL | 100 | 0 | OTHER |
| 1004 | 10001 | 1 | db file data read | db file data read | fd | offset | size | 108 | 8 | USER_IO |
| 1004 | 10002 | 2 | db file data `index read | db file data `index read | fd | offset | size | 108 | 8 | USER_IO |
| 1004 | 11001 | 3 | db file compact read | db file compact read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1004 | 11002 | 4 | db file compact write | db file compact write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1004 | 11003 | 5 | db file index build read | db file index build read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1004 | 11004 | 6 | db file index build write | db file index build write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1004 | 11005 | 7 | db file migrate read | db file migrate read | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1004 | 11006 | 8 | db file migrate write | db file migrate write | fd | offset | size | 109 | 9 | SYSTEM_IO |
| 1004 | 11007 | 9 | bloomfilter build read | bloomfilter build read | fd | offset | size | 109 | 9 | SYSTEM_IO |
+--------+----------+--------+---------------------------+---------------------------+------------+------------+------------+---------------+-------------+------------+
10 rows in set (0.004 sec)