V$SESSION_WAIT

V$SESSION_WAIT_HISTORY

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 additional parameter
`P1`	`NUMBER`	First additional parameter
`P2TEXT`	`VARCHAR2(64)`	Description of the second additional parameter
`P2`	`NUMBER`	Second additional parameter
`P3TEXT`	`VARCHAR2(64)`	Description of the third additional parameter
`P3`	`NUMBER`	Third additional parameter
`WAIT_TIME`	`NUMBER`	A nonzero value is the session's last wait time. A zero value means the session is currently waiting.