From KathyD@belkin.com Fri, 20 Jul 2001 14:35:41 -0700 From: Kathy Duret Date: Fri, 20 Jul 2001 14:35:41 -0700 Subject: RE: SDU and TDU in SQL*NET Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: SDU and TDU in SQL*NET As I understand, you have to run with SQL*NET of version 2.3 and above.  I will let you know what I find out when I get into testing and down the road.    Kathy -----Original Message-----From: Thomas Jeff [mailto:ThomasJe@tce.com]Sent: Friday, July 20, 2001 3:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SDU and TDU in SQL*NET I believe the TDU  parameter is now ignored in Net8. Our tests seems to indicate that it's fixed at 32K. Jeff T. thomasje@tce.com -----Original Message----- From: Orr, Steve [mailto:sorr@rightnow.com] Sent: Friday, July 20, 2001 5:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: SDU and TDU in SQL*NET Here's a sample from tnsnames.ora: . . . yourlabel =   (DESCRIPTION =     (SDU=1500)     (TDU=1500)     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.com)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = your_service)       (SID = your_ORACLE_SID)     )   ) Here's a sample from listener.ora: . . .     (SID_DESC =       (SDU=1500)       (TDU=1500)       (GLOBAL_DBNAME = yourDB.yourhost.com)       (ORACLE_HOME = your_ORACLE_HOME)       (SID_NAME = your_ORACLE_SID)     ) The MTU on Ethernet is 1500 and MTU=SDU=TDU is a recommendation I've seen. No comments on worth... Steve Orr -----Original Message----- Sent: Friday, July 20, 2001 3:51 PM To: Multiple recipients of list ORACLE-L 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve   INET: sorr@rightnow.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@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). ConfidentialThis e-mail and any files transmitted with it are the propertyof Belkin Components and/or its affiliates, are confidential,and are intended solely for the use of the individual orentity to whom this e-mail is addressed.  If you are not oneof the named recipients or otherwise have reason to believethat you have received this e-mail in error, please notify thesender and delete this message immediately from your computer.Any other use, retention, dissemination, forwarding, printingor copying of this e-mail is strictly prohibited.