Oracle

(Difference between revisions)

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

@@ Line 1: / Line 1: @@
-TDU/SDU maximum: 32768
+TDU/SDU maximum: 32768/32768
 TDU/SDU defaults (e.g. local connections): 2048/32768
@@ Line 5: / Line 5: @@
 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]]