Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net message from client waits

Re: SQL*Net message from client waits

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Thu, 28 Jun 2007 01:50:44 GMT
Message-ID: <pan.2007.06.28.01.50.45@verizon.net>


On Wed, 27 Jun 2007 12:46:00 -0700, baba_jaga wrote:

> SQL*Net message to client 343905
> 0.00 0.75
> SQL*Net more data to client 14559
> 0.01 1.14

You actually do have a network problem. SQL*Net message to client means that oracle is spending significant time to send data to the client side. One usually sees that event consuming significant amount of time when the communication between client and server is not optimized. That communication doesn't mean that there is a physical problem on the network, it means that the communication is less then optimal and that Oracle is waiting for the client to acknowledge receipt. Why are the clients waiting with the acknowledgment is open for discussion. It can be a physical network problem or a bad client side application.

-- 
http://www.mladen-gogala.com
Received on Wed Jun 27 2007 - 20:50:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US