Query v$session for WAIT_TIME A nonzero value is the session's last wait time. A zero value means the session is currently waiting 0 - the session is currently waiting -2 - duration of last wait is unknown -1 - last wait was <1/100th of a second in duration >0 - duration of last wait in 1/100th second units (10mS) <-2 - The internal time has probably wrapped SECONDS_IN_WAIT When WAIT_TIME = 0 then this shows the number of seconds spent in the current wait Note: We need to check Wait_Tiem = 0 - implies that sessions are waiting currently waiting and Seconds-In_Wait will specify how much time current session is waiting.