V$SESSION_WAIT : event question

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 18 Nov 1999 08:01:23 +0200
Message-ID: <8104kg$63k$1@ctb-nnrp1.saix.net>

Anyone has an idea what this events is about? :

Event : SQL*Net message from client
Param1: Driver ID
Param2: number of bytes or blocks

I have a process running, still being shown as active, which the users says is now taking forever, and even though rows are being processed (according to session stats), the majority of the events waited on, is this one.

I assume that "message from client" is just that - Oracle gets a row, returns it to the client which in turns processes it, before requesting the next one. This means that from an Oracle Server perspective, the majority of its time for that session is spend waiting for the client to request more data. So the performance problem, if there is one, has then to do with how fast/well the client actually processes the data. Is this assumption valid?

Comments will be much appreciated.

regards,
Billy Received on Thu Nov 18 1999 - 00:01:23 CST