Re: v$session_wait

The wait time goes up by 3 seconds roughly every three seconds. In most cases it is set back to 0 at the start of each wait event (although there are a couple of anomalies about what it means to start waiting).

So wait_time = -1 with seconds_in_wait non-zero means you waited a short time roughly 'seconds_in_wait' seconds in the past - which (ignoring time when your session is runnable but not running) means you've been using that many seconds of CPU since.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals
Now available to pre-order.

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Sept 2005







"Chuck" <skilover_nospam_at_softhome.net> wrote in message 
news:1129738275.d2803d74b6c0d188eeb2f15f2cd8bb2b_at_bubbanews...


> 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"