Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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.