The meaning of the wait_time in v$session_wait and v$session
511057Jul 31 2007 — edited Jul 31 2007I am using the Metalink Note: Diagnosis of High CPU to find out the CPU and query:
select s.sid, s.event, w.wait_time, w.state, q.sql_text
from v$session_wait w, v$session s, v$process p, v$sqlarea q
where s.paddr=p.addr
and s.sid=&p
and s.sql_address=q.address
order by w.wait_time
/
return the wait_time from -1, 0 and >0 (upto 133842)
Based on the 10g R2 reference, -1 is "waited short time", 0 is "waiting" and >0 is "waited known time", which is the session last wait time.
So the wait_time > 0 is probably worse than the other wait_time (ex 133842)? and How to evalute the wait-time good or bad, for example 133842 vs 1918?