V$SESSION_WAIT_CLASS

Oracle 11gR1

V$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis.

Column	Datatype	Description
SID	NUMBER	Session identifier
SERIAL#	NUMBER	Serial number
WAIT_CLASS_ID	NUMBER	Identifier of the wait class
WAIT_CLASS#	NUMBER	Number of the wait class
WAIT_CLASS	VARCHAR2(64)	Name of the wait class
TOTAL_WAITS	NUMBER	Number of times waits of the class occurred for the session
TIME_WAITED	NUMBER	Amount of time spent in the wait class by the session

Note:

1.

select * from V$SESSION_WAIT_CLASS

where sid = 1494;

SID	SERIAL#	WAIT_CLASS_ID	WAIT_CLASS#	WAIT_CLASS	TOTAL_WAITS	TIME_WAITED
1494	12420	4217450380	1	Application	2	0
1494	12420	3386400367	5	Commit	3	0
1494	12420	2723168908	6	Idle	30	28
1494	12420	2000153315	7	Network	35	0

2. Wait Interface (Week 11 from Oracle Database 10g: The Top 20 Features for DBAs)

Oracle dynamic performance views