Re: v$session_wait message

Actually, I think that the wait event that means normal, idle client time is "SQL*Net message from client," not "SQL*Net more data from client." "SQL*Net more data from client" means that the server is expecting additional data that the client indicated it was about to send. If you wait for a long time on this event, there may me something to tune.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah

On Wed, 30 Sep 1998, Jonathan Lewis wrote:
>
> 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.
>
> 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 - 16:44:18 CDT