I believe the TDU parameter is now ignored in Net8.
Our tests seems to indicate that it's fixed at 32K.
Jeff T.
[EMAIL PROTECTED]
-----Original Message-----
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
