首批通过分布式安全可靠测评，为关键业务系统打造
V$EVENT_NAME
更新时间：2026-07-15 20:56:59
编辑
分享
说明
该视图从 V1.4 版本开始引入。
功能描述
展示当前租户下的各种等待事件的定义。
字段说明
| 字段名称 | 类型 | 是否可以为 NULL | 描述 |
|---|---|---|---|
| CON_ID | NUMBER | NO | 租户 ID |
| EVENT_ID | NUMBER | NO | 等待事件 ID |
| EVENT# | NUMBER | NO | 等待事件编号 |
| NAME | VARCHAR2(64) | NO | 等待事件名称 |
| DISPLAY_NAME | VARCHAR2(64) | NO | 等待事件显示名称 |
| PARAMETER1 | VARCHAR2(64) | NO | 等待事件参数 1 |
| PARAMETER2 | VARCHAR2(64) | NO | 等待事件参数 2 |
| PARAMETER3 | VARCHAR2(64) | NO | 等待事件参数 3 |
| WAIT_CLASS_ID | NUMBER | NO | 等待事件所属类型的 ID |
| WAIT_CLASS# | NUMBER | NO | 等待事件所属类型的下标 |
| WAIT_CLASS | VARCHAR2(64) | NO | 等待事件所属类型的名称 |
查询示例
用户租户下，查看本租户下所有等待事件的相关定义，展示前 10 条记录。
obclient [SYS]> SELECT * FROM SYS.V$EVENT_NAME WHERE ROWNUM <= 10;
查询结果如下：
+--------+----------+--------+---------------------------+---------------------------+----------------------+--------------+----------------+---------------+-------------+------------+
| 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 | schedule_queue_delay | device_delay | callback_delay | 108 | 8 | USER_IO |
| 1004 | 10002 | 2 | db file data `index read | db file data `index read | schedule_queue_delay | device_delay | callback_delay | 108 | 8 | USER_IO |
| 1004 | 11001 | 3 | db file compact read | db file compact read | schedule_queue_delay | device_delay | callback_delay | 109 | 9 | SYSTEM_IO |
| 1004 | 11002 | 4 | db file compact write | db file compact write | schedule_queue_delay | device_delay | callback_delay | 109 | 9 | SYSTEM_IO |
| 1004 | 11003 | 5 | db file index build read | db file index build read | schedule_queue_delay | device_delay | callback_delay | 109 | 9 | SYSTEM_IO |
| 1004 | 11004 | 6 | db file index build write | db file index build write | schedule_queue_delay | device_delay | callback_delay | 109 | 9 | SYSTEM_IO |
| 1004 | 11005 | 7 | db file migrate read | db file migrate read | schedule_queue_delay | device_delay | callback_delay | 109 | 9 | SYSTEM_IO |
| 1004 | 11006 | 8 | db file migrate write | db file migrate write | schedule_queue_delay | device_delay | callback_delay | 109 | 9 | SYSTEM_IO |
| 1004 | 11007 | 9 | bloomfilter build read | bloomfilter build read | schedule_queue_delay | device_delay | callback_delay | 109 | 9 | SYSTEM_IO |
+--------+----------+--------+---------------------------+---------------------------+----------------------+--------------+----------------+---------------+-------------+------------+
10 rows in set
相关视图或文档
查看所有 Session 的当前或上一次等待事件：
查看租户级别的所有等待事件：
有关等待事件的详细说明，参见 常见等待事件说明。
