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.