Oracle动态性能视图 v$event_name
V$EVENT_NAME 视图列出了等待事件的一个集合, 它提供了必须等待处理的会话的有关信息:
V$EVENT_NAME
V$EVENT_NAMEdisplays information about wait events.
ColumnDatatypeDescription
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 等待事件类型