Re: N/w Bottleneck Check under Benchmark Load & Event "SQL*Net more data from client"
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Tue, 1 Jul 2008 09:45:30 -0500
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@xxxxxxxxxxx>
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***
>
>
Other related posts:
