Re: SQL*Net message from client waits

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