V$EVENT_NAME

Oracle 11gR1

V$EVENT_NAME displays information about wait events. It is a collection of wait events provides information about the sessions or processes that had to wait or must wait for different reasons.

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

Note:

1.

select * from V$EVENT_NAME where event#<10;

EVENT#	EVENT_ID	NAME	PARAMETER1	PARAMETER2	PARAMETER3	WAIT_ CLASS_ID	WAIT_ CLASS#	WAIT_ CLASS
0	2516578839	null event				1893977003	0	Other
1	3539483025	pmon timer	duration			2723168908	6	Idle
2	866018717	rdbms ipc message	timeout			2723168908	6	Idle
3	3083157888	kst: async disk IO	count	intr	timeout	4108307767	9	System I/O
4	2324796046	ksfd: async disk IO	count	intr	timeout	4108307767	9	System I/O
5	4155572307	Datapump dump file I/O	count	intr	timeout	1740759767	8	User I/O
6	1791724291	dbms_file_transfer I/O	count	intr	timeout	1740759767	8	User I/O
7	432473858	DG Broker configuration file I/O	count	intr	timeout	1740759767	8	User I/O
8	2326919048	Data file init write	count	intr	timeout	1740759767	8	User I/O
9	3992632846	Log file init write	count	intr	timeout	1740759767	8	User I/O

Oracle dynamic performance views