RE: Network Tuning

The tdu is on the server side the sdu is on the client side - in order to work best they should be the same - I have set mine at 16K - lots of long or clob data (my users like to enter lots of comments).

.... . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw
Intergraph Public Safety
mailstop LR24A4
jbshaw_at_ingr.com
256-730-8038
All the usual disclaimers and some of the certifications

-----Original Message-----
From: Rajesh Dayal [mailto:Rajesh_at_ohitelecom.com] Sent: Monday, September 18, 2000 10:27 AM To: Multiple recipients of list ORACLE-L Subject: Network Tuning

> Hi guys,
> I have got some advice on N/W tuning after getting
my report.txt analyzed at oraperf.com.
>
> A portion of report generated at your site is as follows :
>
> >>
> SQL*Net more data to client
> The client side is selecting large records and/or is using array
> fetch. Basically the Oracle Server is sending more data than will fit
> in a SQL*Net package. Increasing the package size will help to reduce
> this event and will help to improve performance. One needs to be using
> Net 2.3 or higher to set the SDU and TDU sizes at client AND the
> server side.
> <<
>
> At the end of the report it shows that this might give me a
> performance gain
> of upto 35%.
>
> SDU, I am familiar with and know that how to tune it, but how
> about TDU.
> How to change and tune TDU size and what effects it has. Also it is
> suggested to
> increase the package size, which is certainly not the SDU, then how
> to increase the
> package size?
>
> Thanks in Advance,
> Rajesh
>

-- 
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).