My Oracle Support Banner

Performance Degradation After Upgrade Of JDBC OracleOCIConnectionPool.getProxyConnection (Doc ID 2124621.1)

Last updated on FEBRUARY 03, 2019

Applies to:

JDBC - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

After upgrade to 12.1.0.2 JDBC OCI drivers (full client and ojdbc7.jar with JDK 1.8), markedly slower performance is seen, specifically in the OracleOCIConnectionPool.getProxyConnection() method.

A java program using the OCI Connection Pool takes a long time to get a connection from the pool using ociPool.getConnection() on Windows platforms.
The time varies from a few msec to 5 or 10 seconds, depending on the entries in sqlnet.ora.

If no sqlnet.ora is defined in the environment, the program takes 10 seconds.
If sqlnet.ora is defined in the environment, and NAMES.DIRECTORY_PATH is set to more than one entry like: NAMES.DIRECTORY_PATH = (TNSNAMES,EZCONNECT), the program takes 5 seconds.
If NAMES.DIRECTORY_PATH is set to only one entry like NAMES.DIRECTORY_PATH=(TNSNAMES), it takes only a few msec.

The delay is not seen on Linux.



Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.