How to specify SDU (session data unit) size in direct connection mode connectionstring

How to specify SDU (session data unit) size in direct connection mode connectionstring

Postby sumit » Tue 09 Jan 2007 01:51

Hi,

We are trying to optimize our application that uses CoreLab oradirect.net 3.55.16 drivers to connect to Oracle database using direct connection (clientless) mode.

On the server side, we changed the listener.ora file to set the SDU to 8192 bytes using the following syntax:
Code: Select all
    (SID_DESC =
      (GLOBAL_DBNAME = falconda)
      (SDU=8192)
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = falconda)
    )


In the absense of tnsnames.ora file (not required for a direct connection mode), how to we specify this information in the connectionstring. If we had a tnsnames.ora file on the application server, we could have used something like this:

Code: Select all
FALCONDA =
  (DESCRIPTION =
  (SDU=8192)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = newyork)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = falconda)
    )
  )
sumit
 
Posts: 62
Joined: Wed 03 Jan 2007 22:23

Postby Alexey » Tue 09 Jan 2007 08:13

Unfortunately, it is not possible to set SDU in direct mode.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle