Configure SDU in connection string with oracle 11G

Question

I do not reference the sqlnet.ora file for search, and pretty much provide the following TNS URL for the connection, and I need to compress the SDU settings in the connection URL below. I was wondering where it will go and what the new URL will look like?

Here is what I use: jdbc:oracle:thin:@192.168.191.231:1521:naladomain

Now I need squezze in sdu customization in the above TNS line. How can I do it?: -)

Thanks!

Answer 1

You need to use the long TNS format (according to the tnsnames.ora file). Like this:

 jdbc:oracle:thin:@(DESCRIPTION=(SDU=32767)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.191.231)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=naladomain)) 

Change the values ​​to suit your needs.