No. The session is waiting if the state is 'WAITING'.
The 'wait_time = 0' thing was true in earlier versions
of Oracle but got broken in v9 when the timings changed
to microseconds and the decodes weren't brought up
to date.
The problem has been fixed, but I don't know which
version of 9 fixed it - so as a guideline, don't look in
the wrong place in case you get the wrong answer.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 4th Nov 2005
Juan, I think that's the correct view.
-- //www.freelists.org/webpage/oracle-l