How to set session data unit (SDU) size in direct connect mode?

[genesplitter]

Is it possible to set the SDU size in direct connect mode? I added an "SDU" parameter to my web.config but this does not work. My web.config is in the following format:

connectionString="User Id=donny;Password=secret;Server=sales;Home=ora102;Direct=True;Sid=oraclesid;;Persist Security Info=True;"

Here is an SDU example from the Oracle documentation:

sales.us.example.com=
(DESCRIPTION=
(SDU=11280)
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=sales.us.example.com))
)

Should the connection string be in a different format or should the SDU size be set somewhere else?

[DmitryGm]

You can specify the Server connection string parameter in a format like in the tnsnames.ora file. See the documentation:
https://www.devart.com/dotconnect/oracl ... tMode.html (RAC Support in Direct Mode)

In your case the connection string could look something like this:

Code: Select all

string connectionString =
    "Server=(DESCRIPTION=" +
    "  (SDU = 11280)" +
    "  (ADDRESS = (PROTOCOL = tcp)(HOST = sales)(PORT = 1521))" +
    "    (CONNECT_DATA =" +
    "    (SID = oraclesid)" +
    "  )" +
    " );" +
    "Direct=True;User Id=donny;Password=secret;";