V$SESSION_WAIT_HISTORY

Oracle 11gR1

V$SESSION_WAIT_HISTORY displays the last 10 wait events for each active session.

Column	Datatype	Description
SID	NUMBER	Session identifier
SEQ#	NUMBER	Sequence of wait events; 1 is the most recent
EVENT#	NUMBER	Event number
EVENT	VARCHAR2(64)	Resource or event for which the session is waiting
P1TEXT	VARCHAR2(64)	Description of the first wait event parameter
P1	NUMBER	First wait event parameter (in decimal)
P2TEXT	VARCHAR2(64)	Description of the second wait event parameter
P2	NUMBER	Second wait event parameter (in decimal)
P3TEXT	VARCHAR2(64)	Description of the third wait event parameter
P3	NUMBER	Third wait event parameter (in decimal)
WAIT_TIME	NUMBER	Amount of time waited (in hundredths of a second)
WAIT_TIME_MICRO	NUMBER	Amount of time waited (in microseconds)
TIME_SINCE_LAST_WAIT_MICRO	NUMBER	Time elapsed (in microseconds) since the end of the previous wait in the wait history

Note:

1.

select * from V$SESSION_WAIT_HISTORY where sid = 1486;

SID	SEQ#	EVENT#	EVENT	P1TEXT	P1	P2TEXT	P2	P3TEXT	P3	WAIT_ TIME	WAIT_ COUNT
1486	1	252	SQL*Net message to client	driver id	1952673792	#bytes	1		0	0	1
1486	2	114	log file sync	buffer#	5134		0		0	2	1
1486	3	256	SQL*Net message from client	driver id	1952673792	#bytes	1		0	0	1
1486	4	252	SQL*Net message to client	driver id	1952673792	#bytes	1		0	0	1
1486	5	115	db file sequential read	file#	67	block#	48251	blocks	1	2	1
1486	6	115	db file sequential read	file#	67	block#	106309	blocks	1	1	1
1486	7	115	db file sequential read	file#	67	block#	51472	blocks	1	1	1
1486	8	256	SQL*Net message from client	driver id	1952673792	#bytes	1		0	0	1
1486	9	252	SQL*Net message to client	driver id	1952673792	#bytes	1		0	0	1
1486	10	256	SQL*Net message from client	driver id	1952673792	#bytes	1		0	0	1

Oracle dynamic performance views