Oracle动态性能视图 v$event_name

文章由LinuxBoy分享于2019-03-30 07:03:30热评（444）

V$EVENT_NAME 视图列出了等待事件的一个集合, 它提供了必须等待处理的会话的有关信息:

官方文档参考

V$EVENT_NAME

V$EVENT_NAMEdisplays 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
`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

列名解释

EVENT# 事件号

EVENT_ID 事件ID

NAME 事件名称

PARAMETER1，PARAMETER2，PARAMETER3 与等待事件相关的3个参数

WAIT_CLASS_ID 等待事件的所属类ID

WAIT_CLASS# 等待事件的类号

WAIT_CLASS 等待事件类型

推荐文章：