v$session_wait

Does the seconds_in_wait column of this view have any meaning if wait_time = -1? The docs don't say what relevance it has if wait_time =
-1 but I recently saw a session where seconds_in_wait was steadily
increasing where the wait_event was latch_free and wait_time was -1.

oracle 9.2
Solaris 8

TIA Here's what the docs say...

If WAIT_TIME = 0, then SECONDS_IN_WAIT is the seconds spent in the current wait condition. If WAIT_TIME > 0, then SECONDS_IN_WAIT is the seconds since the start of the last wait, and SECONDS_IN_WAIT - WAIT_TIME / 100 is the active seconds since the last wait ended.

--

To reply by email remove "_nospam" Received on Wed Oct 19 2005 - 12:23:02 CDT