RE: SDU and TDU in SQL*NET

From: Kathy Duret <KathyD_at_belkin.com>
Date: Fri, 20 Jul 2001 14:35:41 -0700
Message-ID: <F001.003508C3.20010720145146@fatcity.com>

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. 

<SPAN
class=070214921-20072001> 
<SPAN
class=070214921-20072001>Kathy

<FONT face=Tahoma

  size=2>-----Original Message-----From: Thomas Jeff   [mailto:ThomasJe_at_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_at_tce.com
  -----Original Message----- From: Orr,   Steve [mailto:sorr_at_rightnow.com]
  Sent: Friday, July 20, 2001 5:23 PM <FONT   size=2>To: Multiple recipients of list ORACLE-L <FONT   size=2>Subject: RE: SDU and TDU in SQL*NET   Here's a sample from tnsnames.ora: . .   . yourlabel =  
  (DESCRIPTION =     (SDU=1500)
      (TDU=1500) <FONT
  size=2>    (ADDRESS_LIST = <FONT
  size=2>      (ADDRESS = (PROTOCOL = TCP)(HOST =   yourhost.com)(PORT = 1521))    
  )     (CONNECT_DATA = <FONT
  size=2>      (SERVICE_NAME = your_service)         (SID = your_ORACLE_SID)
      )   )   

  Here's a sample from listener.ora: . .   .     (SID_DESC = <FONT

  size=2>      (SDU=1500) <FONT 
  size=2>      (TDU=1500) <FONT 
  size=2>      (GLOBAL_DBNAME = 

  yourDB.yourhost.com)      
  (ORACLE_HOME = your_ORACLE_HOME) <FONT   size=2>      (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 <FONT   size=2>documentation and/or samples and have only found: <FONT

  size=2>---------------------------------------------------------------------------- 

<FONT

  size=2>---------------------------------------------------------------------------- 
  --------------------------------- 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 <FONT   size=2>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. <FONT

  size=2>---------------------------------------------------------------------------- 

<FONT

  size=2>---------------------------------------------------------------------------- 
  -------------------------------- 

  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 -- <FONT
  size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com"   target=_blank>http://www.orafaq.com --   Author: Orr, Steve  
  INET: sorr_at_rightnow.com
  Fat City Network Services    -- (858)   538-5051  FAX: (858) 538-5051 San Diego,   California        -- Public Internet access   / Mailing Lists <FONT

  size=2>-------------------------------------------------------------------- 

  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).

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. Received on Fri Jul 20 2001 - 16:35:41 CDT