Re: N/w Bottleneck Check under Benchmark Load & Event "SQL*Net more data from client"

From: Cary Millsap <cary.millsap_at_method-r.com>
Date: Tue, 1 Jul 2008 09:45:30 -0500
Message-ID: <3a2a84fc0807010745jbe8fdcax15e8da42880dfcf0@mail.gmail.com>


It's not necessarily the network's fault, though. The "more data" event means that the kernel-side software has received part of a dbcall from the client, but the whole call wouldn't fit into one packet. You gotta wonder why a call would be bigger than a packet can hold. Either the packets are too small (the usual first guess), or a client application is sending big SQL statements that would have better been stored server-side in PL/SQL packages that you could call through a procedure/function interface.

Cary Millsap
http://method-r.com
http://carymillsap.blogspot.com

On Tue, Jul 1, 2008 at 3:01 AM, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:

> Folks
>
>
>
> For a OLTP Benchmark under Transaction Load is event "SQL*Net more data
> from client" an indication of Network Choke
>
> Currently a 100 MBPS LAN Cable connects APP to DB Server.
>
>
>
> Oracle 10.2.3.0 (NON-RAC)
>
> Application - Banking Java Application using Oracle thin driver to connect
> to the Database.
>
> HP-UX 11.11
>
>
>
> Cheers & Thanks V much
>
>
>
> Vivek
>
> P.S.
>
>
>
> *Snap Time*
>
> Begin Snap: 30-Jun-08 19:17:41
>
> End Snap: 30-Jun-08 19:26:43
>
> Elapsed: 9.03 (mins)
>
> DB Time: 9.06 (mins)
>
>
>
>
>
> Top 5 Timed Events Avg
> %Total
>
> ~~~~~~~~~~~~~~~~~~ wait
> Call
>
> Event Waits Time (s) (ms)
> Time *Wait Class*
>
> ----------------------------------------- ------------ ----------- ------
> ------ -------
>
> *SQL*Net more data from client* *338,920
> 149 0* *20.3 Network***
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
> for the use of the addressee(s). If you are not the intended recipient, please
> notify the sender by e-mail and delete the original message. Further, you are not
> to copy, disclose, or distribute this e-mail or its contents to any other person and
> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
> every reasonable precaution to minimize this risk, but is not liable for any damage
> you may sustain as a result of any virus in this e-mail. You should carry out your
> own virus checks before opening the e-mail or attachment. Infosys reserves the
> right to monitor and review the content of all messages sent to or from this e-mail
> address. Messages sent to or from this e-mail address may be stored on the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 01 2008 - 09:45:30 CDT

Original text of this message