Re: v$session_wait message

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 30 Sep 1998 18:52:30 GMT
Message-ID: <01bdeca2$fdf54a50$0300a8c0@WORKSTATION>

Don't worry -

In virtually any OLTP type of application almost all sessions will be waiting almost all the time for their clients to do something.

This just means the SQl has completed, and server is waiting for the next call to arrive.

Jonathan Lewis.

Cheng-Jih Chen <cjc_at_interport.net> wrote in article <6urfcj$984$1_at_interport.net>...
> I'm querying v$session_wait on a particular session and am seeing
this:
>
> EVENT STATUS
> --------------------------------- -----------------
> SQL*Net more data from client WAITING
>
> What exactly does this wait event mean? As far as we can tell, the
> program shouldn't be stopped at that point.
>
Received on Wed Sep 30 1998 - 13:52:30 CDT