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

It seems to me that you need to send larger packets to the server. Increase the SDU parameter and try again.

Check out metalink note:*44694.1*
*SQL*Net Packet Sizes (SDU & TDU Parameters).

*

Adar Yechiel
Rechovot, Israel

VIVEK_SHARMA 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