Oracle教程 2023-04-02

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

V$EVENT_NAME是可通过v$fixed_view视图查询的一个性能视图，它显示了当前数据库中 name 和 number对应的临时（活动）事件信息。

使用V$EVENT_NAME可以查询当前正在运行的活动事件信息，并从中可查看到事件名称和编号、正在运行的事件以及它们的文件名等信息。通过使用该视图，可以检查当前运行活动以及它们可能出现的性能问题，以便及时处理。

V$EVENT_NAME displays information about wait events.

Column	Datatype	Description
`EVENT#`	`NUMBER`	Number of the wait event
`EVENT_ID`	`NUMBER`	Identifier of the wait event
`NAME`	`VARCHAR2(64)`	Name of the wait event. Names that appear in this column remain stable across Oracle Database releases, and they can be relied on by customer scripts.
`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#`	`NUMBER`	Number of the class of the wait event
`WAIT_CLASS`	`VARCHAR2(64)`	Name of the class of the wait event See Also: “Classes of Wait Events” for a description of the different wait event classes
`DISPLAY_NAME`	`VARCHAR2(64)`	A clearer and more descriptive name for the wait event that appears in the `NAME` column. Names that appear in the `DISPLAY_NAME` column can change across Oracle Database releases, therefore customer scripts should not rely on names that appear in the `DISPLAY_NAME` column across releases.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. 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

分享到：