How to specify SDU (session data unit) size in direct connection mode connectionstring
Posted: 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:
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:
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)
)
Code: Select all
FALCONDA =
(DESCRIPTION =
(SDU=8192)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = newyork)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = falconda)
)
)