Oracle教程 2023-02-24

Oracle 视图 DBA_HIST_EVENT_NAME 官方解释，作用，如何使用详细说明

Oracle视图DBA_HIST_EVENT_NAME用于查询Oracle数据库历史事件名称，即事件号对应的事件名。它映射了数据库内部使用的数字事件号和历史事件名称。这个视图可以帮助你从数据库视图和历史表和日志中查看到具体的事件名称，而不是只对应一个数字事件号。

使用方法：

通过SQL语句SELECT * FROM dba_hist_event_name;可以检索所有的事件名称。

SELECT event_name,event_id FROM dba_hist_event_name WHERE event_id=50; 可以检索特定事件号对应的历史事件名称。

DBA_HIST_EVENT_NAME displays information about wait events.

This view contains a snapshot of V$EVENT_NAME.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID
`EVENT_ID`	`NUMBER`	`NOT NULL`	Identifier of the wait event
`EVENT_NAME`	`VARCHAR2(64)`	`NOT NULL`	Name of the wait event
`PARAMETER1`	`VARCHAR2(64)`		Description of the first parameter for the wait event
`PARAMETER2`	`VARCHAR2(64)`		Description of the second parameter for the wait event
`PARAMETER3`	`VARCHAR2(64)`		Description of the third parameter for the wait event
`WAIT_CLASS_ID`	`NUMBER`		Identifier of the class of the wait event
`WAIT_CLASS`	`VARCHAR2(64)`		Name of the class of the wait event
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data