DBA Data[Home] [Help]

VIEW: SYS.GV_$SESSION_WAIT_HISTORY

Source

View Text - Preformatted

select "INST_ID","SID","SEQ#","EVENT#","EVENT","P1TEXT","P1","P2TEXT","P2","P3TEXT","P3","WAIT_TIME","WAIT_TIME_MICRO","TIME_SINCE_LAST_WAIT_MICRO","CON_ID" from gv$session_wait_history
View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "SEQ#"
, "EVENT#"
, "EVENT"
, "P1TEXT"
, "P1"
, "P2TEXT"
, "P2"
, "P3TEXT"
, "P3"
, "WAIT_TIME"
, "WAIT_TIME_MICRO"
, "TIME_SINCE_LAST_WAIT_MICRO"
, "CON_ID"
FROM GV$SESSION_WAIT_HISTORY