Oracle dynamic performance view v $ event_name

Oracle dynamic performance view v $ event_name

The V $ EVENT_NAME view lists a set of waiting events. It provides information about sessions that must be waiting for processing:

Official Document reference

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

Column name explanation

EVENT # EVENT number

EVENT_IDEvent ID

NAME event NAME

PARAMETER1,PARAMETER2,PARAMETER3 parameters related to the wait event

WAIT_CLASS_IDClass ID of the wait event

WAIT_CLASS#ID of the waiting event

WAIT_CLASSWait Event Type

1 2 Next Page