Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLNET: What's the size of the socket buffers ?
For the Oracle Sqlnet documentation:
"Adjusting SDU Buffer Size
Before sending data across the network, SQL Net buffers data into the Session Data Unit (SDU). It sends the data stored in this buffer when the buffer is full or when an application tries to read the data. When large amounts of data are being retrieved, and when packet size is consistently the same, it may speed retrieval to adjust the default SDU size.
Optimal SDU size depends on the normal packet size. Use a sniffer to find out the frame size, or set tracing on to its highest level to check the number of packets sent and received, and to see if they are fragmented. Tune your system to limit the amount of fragmentation.
Use Oracle Network Manager to configure a change to the default SDU size on both the client and the server; SDU size should generally be the same on both.
Modify session data unit size when:
1.The data coming back from the server is
fragmented into separate packets 2.You are on a wide area network (WAN) that has
long delays
3.Your packet size is consistently the same
4.Large amounts of data are returned"
Did not quite answer your question, does it?
alawa_at_bandol.concept.fr wrote:
: Does Oracle modify the default size of the socket buffers ?
: The of SNDBUF and RCVBUF are by default set to 8192 on NT and W95
: and 16384 on AiX 4.
: Does anybody know the relation with the SDU oracle variable ?
-- Received on Sat Nov 14 1998 - 18:30:36 CST