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

sumit · Post by **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)
    )
  )

Alexey · Post by **Alexey** » Tue 09 Jan 2007 08:13

Unfortunately, it is not possible to set SDU in direct mode.