Oracle

From SkyWiki

(Difference between revisions)
Jump to: navigation, search
(New page: TDU/SDU maximum: 32768 TDU/SDU defaults (e.g. local connections): 2048/32768 TDU/SDU on Ethernet: 8760/1500 category:Oracle)
Current revision (20:47, 4 October 2008) (view source)
 
Line 1: Line 1:
-
TDU/SDU maximum: 32768
+
TDU/SDU maximum: 32768/32768
TDU/SDU defaults (e.g. local connections): 2048/32768
TDU/SDU defaults (e.g. local connections): 2048/32768
Line 5: Line 5:
TDU/SDU on Ethernet: 8760/1500
TDU/SDU on Ethernet: 8760/1500
 +
 +
To optimize a connection you have to insert TDU/SDU values both on server and client side:
 +
 +
listener.ora
 +
<code>
 +
SID_DESC_LISTENER =
 +
(SID_LIST =
 +
  (SID_DESC =
 +
  (TDU = 32768)
 +
  (SDU = 32768)
 +
  (SID_NAME=...
 +
</code>
 +
 +
tnsnames.ora
 +
<code>
 +
DB.WORLD =
 +
(DESCRIPTION =
 +
(TDU = 32768)
 +
(SDU = 32768)
 +
(CONNECT_DATA =...
 +
</code>
 +
 +
 +
see also:
 +
 +
http://www.experts-exchange.com/Databases/Oracle/Product_Info/Q_21101591.html
 +
 +
http://www.dba-oracle.com/tips_oracle_tnsnames_ora_file.htm
[[category:Oracle]]
[[category:Oracle]]

Current revision

TDU/SDU maximum: 32768/32768

TDU/SDU defaults (e.g. local connections): 2048/32768

TDU/SDU on Ethernet: 8760/1500


To optimize a connection you have to insert TDU/SDU values both on server and client side:

listener.ora SID_DESC_LISTENER = (SID_LIST =

 (SID_DESC =
 (TDU = 32768)
 (SDU = 32768)
 (SID_NAME=...

tnsnames.ora DB.WORLD = (DESCRIPTION =

(TDU = 32768)
(SDU = 32768)
(CONNECT_DATA =...


see also:

http://www.experts-exchange.com/Databases/Oracle/Product_Info/Q_21101591.html

http://www.dba-oracle.com/tips_oracle_tnsnames_ora_file.htm

Personal tools