Xref: alice comp.databases.oracle.server:74542 Path: alice!news-feed.fnsi.net!news.new-york.net!newshub.northeast.verio.net!verio!news-out.cwix.com!newsfeed.cwix.com!ctb-nntp1!not-for-mail From: "Billy Verreynne" Newsgroups: comp.databases.oracle.server Subject: V$SESSION_WAIT : event question Date: Thu, 18 Nov 1999 08:01:23 +0200 Organization: Verreynne Software Labs Lines: 24 Message-ID: <8104kg$63k$1@ctb-nnrp1.saix.net> X-Trace: ctb-nnrp1.saix.net 942904784 6260 198.54.206.114 (18 Nov 1999 05:59:44 GMT) X-Complaints-To: abuse@saix.net NNTP-Posting-Date: 18 Nov 1999 05:59:44 GMT X-Newsreader: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 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