Re: v$session_wait

Chuck wrote:
> 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
>

Hi, Chuck,

If you look at v$fixed_view_definition for GV$SESSION_WAIT, you'll see STATE and WAIT_TIME columns come from the same source, but STATE is more readable. Documentation about STATE says

-1 - WAITED SHORT TIME (last wait <1/100th of a second)

In your case, the session frequently waits on 'latch free' and every time it very quickly gets it (so quick that Oracle's timing resolution is too coarse). Your SEQ# should keep going up. Tune the application or database based on the type of latch.

Yong Huang Received on Wed Oct 19 2005 - 13:06:02 CDT