My Oracle Support Banner

"InactiveConnectionTimeout Creates A Lot Of Sessions" Is Still Reproduced In 19.3 (Bug 11725265) (Doc ID 2597130.1)

Last updated on JULY 21, 2023

Applies to:

Universal Connection Pool - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.3.0.0.0 version, Connection Pool Management

ACTUAL BEHAVIOR
---------------
Running the basicSample.java program provided below with a low inactivity connection timeout created a lot of sessions in the database.
Results are similar to this:

-----------
wait 5 minutes:
-----------
NumberOfAvailableConnections: 20 BorrowedConnectionsCount: 0
Statistics:
Cumulative ConnectionCreatedCount: 30 Cumulative ConnectionReturnedCount: 30 TotalConnectionCreatedCount: 50
TotalConnectionClosedCount: 30
TotalConnectionCount: 20
-----------


EXPECTED BEHAVIOR
-----------------------
The expected behavior is this:

-----------
wait 5 minutes:
-----------
NumberOfAvailableConnections: 20 BorrowedConnectionsCount: 0
Statistics:
Cumulative ConnectionCreatedCount: 30 Cumulative ConnectionReturnedCount: 30 TotalConnectionCreatedCount: 30
TotalConnectionClosedCount: 10
TotalConnectionCount: 20
-----------

Changes

 

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
Changes
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.