SDU Ignored By The JDBC Thin Client Connection
(Doc ID 2652240.1)
Last updated on MARCH 30, 2020
Applies to:JDBC - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
There is the need to increase the SDU size of the database connections to 32K (or more) to improve performance of a Java application using JDBC Thin 18.3.
The database is a single instance multi-tenant database running on a 4 node cluster. GI is 188.8.131.52 and RDBMS is on 184.108.40.206.
The following has been implemented:
- Set DEFAULT_SDU_SIZE=131072 in sqlnet.ora of RDBMS home on all the nodes of the cluster, as well as set DEFAULT_SDU_SIZE=131072 in sqlnet.ora file of GI home.
SCAN and local listeners are restarted on all the nodes of the cluster.
- The sqlnet.ora file is updated on the client and DEFAULT_SDU_SIZE=131072 was added to it, and also (SDU=32768) was added to the TNS entries used by SQL*Plus connections.
- Additionally, the JDBC URL is set to include (SDU=32768) like the following:
jdbc:oracle:thin:@(DESCRIPTION=(SDU=32768) (ADDRESS=(PROTOCOL=TCP) (HOST=<PORT>) (PORT=<PORT>)) (CONNECT_DATA=(SERVICE_NAME=<SERVICA NAME>)))
From SQL Plus (and Toad), when connecting to SCAN or LOCAL listeners, tracing connections shows that SDU size of 32K is used.
From SQL Developer (or Java application), when connecting to SCAN listener, the trace shows the connection is using the default 8K of SDU.
JDBC seems to ignore the SDU setting in the connection string.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document