RE: SDU and TDU in SQL*NET

From: Thomas Jeff <ThomasJe_at_tce.com>
Date: Fri, 20 Jul 2001 14:27:41 -0700
Message-ID: <F001.00350890.20010720144041@fatcity.com>

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
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_at_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_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 - 16:27:41 CDT