Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Excessive SQL*Net message from client waits
Good point, but what if each user only has a single session?
Not that I've noticed this exact same situation here on one of our Engineering support databases whose clients are Java, and I'm not wondering if it has something to do with the application or if I can possibly speed it up with tweaks to SDU/TDU. I'm just wondering... ;)
Rich
Rich Jesse System/Database Administrator rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Thursday, March 13, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L
But if one user spawns 10 sessions, then whilst one session is being 'clicked' the other 9 are idle - no matter how fast the user is being bounced from one to the next - so on average every session is going to be waiting for "SQL*Net message from client" 90% of the time.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
> Not like this nor should it be the "top" event always as seems to be
the
> case here I don't believe. And, I know for certain that the client
did
> everything as quickly as possible during the trace. Minimal data
entry done
> and OK buttons clicked without delay...no time out for getting a cup
of
> coffee in between or anything. :)
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Mar 13 2003 - 09:54:10 CST
![]() |
![]() |