My Oracle Support Banner

JDBC Thin Client Oracle Sessions are not being closed (Doc ID 2890302.1)

Last updated on AUGUST 19, 2022

Applies to:

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


When using jdbc thin to connect to the oracle database, it was observed that when the application (JDBC connections) generates a report, the sessions on the db side reached around 45 and immediately killed by the database and the sessions resets to 4 sessions. However, when using jdbc 19.15, it was observed that sessions are keeping increasing and are not closed.

The issue was observed on physical server with a single CDB with one PDB or multiple cdbc with multiple pdbs. It takes 6 mins to generate a report.


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

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