Re: SDU setting - tnsnames, listener.ora

Chris Kempster wrote:
>
> Does anyone know what SDU means?, the parameter can be used in the tnsnames

SendDataUnit perhaps - I've seen it before and depending on the typical packet
size that the Server is sending back to the client may make it more effective
if the average pktsize is greater than 4K to increase (as you have found out).
It's a case of suck and see. The other usefull parameter goes into protocol.ora
and is something like TCPNODELAY=ON, read up about the Nagle Algorithm but essentially
if you have two large machines talking through high speed comms with LARGE TCPIP Buffer
spaces, you pay a penalty if the buffer is not filled up to half way with
data, ASSERT(fuzzymemory)(~200ms/pkt) ASSERT(OFF)  

I know on AIX you need to request the patch from Oracle support to enable the
feature (7.3.3 ???????)

Hope that helps

Dominic

> and listener.ora files and has a default value of 4Kb (to 32Kb). After some
> prelim testing is can improve sql*net connectivity from client to server
> from about 5 to 20%. I picked up the parameter from an old sql*net tuning
> white paper done in early 96/97 but after searching all the sql*net manuals
> can find nothing on it.
>
> Any ideas?
Received on Sat Jun 20 1998 - 20:01:31 CDT