> 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,
Received on Mon Sep 18 2000 - 09:27:34 CDT
