SDU and TDU in SQL*NET

From: Kathy Duret <KathyD_at_belkin.com>
Date: Fri, 20 Jul 2001 13:37:58 -0700
Message-ID: <F001.003507A1.20010720135039@fatcity.com>

I have recently run various statspack reports and ult report against my 8.1.6 database. It suggests that I am sending more data on the client side than will fit into one SQL*NET package. I have been looking for documentation and/or samples and have only found:

The SDU size should be set as a multiple of the normal transport frame size. Since the normal Ethernet frame size is 1500, the most efficient SDU size over an Ethernet protocol should be a multiple of 1500.
If you are using either connection pooling or connection concentration, keep in mind that these features require an additional 16 bytes per transport. For more information about the protocol frame size, refer to your operating-system-specific documentation.

I am not sure how to set this parameter or how to find out the protocol frame size you are using. Anybody have any experience using this? Is it worth the effort? Any samples of how to set?

Thanks,

Kathy

Confidential
This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kathy Duret
INET: KathyD_at_belkin.com

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: ListGuru_at_fatcity.com (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 Fri Jul 20 2001 - 15:37:58 CDT