V$SESSION_EVENT

Oracle 11gR1

V$SESSION_EVENT displays information on waits for an event by a session. Note that the TIME_WAITED and AVERAGE_WAIT columns will contain a value of zero on those platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you want this column to reflect true wait times, you must set TIMED_STATISTICS to true in the parameter file. Please remember that doing this will have a small negative effect on system performance.

Column	Datatype	Description
SID	NUMBER	ID of the session
EVENT	VARCHAR2(64)	Name of the wait event
TOTAL_WAITS	NUMBER	Total number of waits for the event by the session
TOTAL_TIMEOUTS	NUMBER	Total number of timeouts for the event by the session
TIME_WAITED	NUMBER	Total amount of time waited for the event by the session (in hundredths of a second)
AVERAGE_WAIT	NUMBER	Average amount of time waited for the event by the session (in hundredths of a second)
MAX_WAIT	NUMBER	Maximum time waited for the event by the session (in hundredths of a second)
TIME_WAITED_MICRO	NUMBER	Total amount of time waited for the event by the session (in microseconds)
EVENT_ID	NUMBER	Identifier of 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$SESSION_EVENT;

SID	EVENT	TOTAL_ WAITS	TOTAL_ TIMEOUTS	TIME_ WAITED	AVERAGE_ WAIT	MAX_ WAIT	TIME_ WAITED_ MICRO	EVENT_ID	WAIT_ CLASS_ID	WAIT_ CLASS#	WAIT_ CLASS
1487	log file sync	3	0	0	0.15	0	4427	1328744198	3386400367	5	Commit
1487	SQL*Net message to client	57	0	0	0	0	47	2067390145	2000153315	7	Network
1487	SQL*Net more data to client	238	0	0	0	0	2983	554161347	2000153315	7	Network
1487	SQL*Net message from client	56	0	167833	2997.02	167724	1678331900	1421975091	2723168908	6	Idle
1487	SQL*Net more data from client	4	0	0	0.01	0	442	3530226808	2000153315	7	Network
1488	log file sync	8	0	1	0.08	0	6277	1328744198	3386400367	5	Commit

Oracle dynamic performance views