Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Network Tuning

RE: Network Tuning

From: Shaw, John B <>
Date: Tue, 19 Sep 2000 06:04:28 -0500
Message-Id: <>

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
All the usual disclaimers and some of the certifications

-----Original Message-----
From: Rajesh Dayal [] 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
> 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

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: (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).
Received on Tue Sep 19 2000 - 06:04:28 CDT

Original text of this message