RE: SDU and TDU in SQL*NET

From: Orr, Steve <sorr_at_rightnow.com>
Date: Fri, 20 Jul 2001 14:13:00 -0700
Message-ID: <F001.0035083D.20010720142259@fatcity.com>

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:13:00 CDT