Re: SQL*net running over 64Kbps

You may need to use the SDU paramter for sqlnet. SDU stands for Session Data Unit and is the size of sqlnet packets going over the net. Here's a typical scenario. Ethernet packets are sent 1500 bytes at a time (approx.). The default SDU size is 2048 bytes. This obviouly results in packet fragmentation. However, if you set SDU to 1400 bytes (allowing about 100 bytes for header information), you may eliminate fragmentation, and acheive better performance. sqlnet 2.0, 2.1, and 2.2 have a default and maximum SDU size of 2k. sqlnet 2.3 allows you to go as high as 32k. Examine your network and see which would be best for you. You set SDU in the client's tnsnames.ora file, and here is how your TNSNAMES.ORA file will look with the SDU parameter:

alias=

(description=
(sdu=1400)
(address=

		(protocol=tcp)
		(host=xxx.xxx.xxx.xxx)
		(port=1521)
	)


	(conect_data=(sid=<sid>)))