Extreme Number Of Inactive Sessions From Application Server Using Implicit Connection Cache (ICC) (Doc ID 1381643.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 11.1.0.7 to 11.2.0.3.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

On : 11.1.0.7 version, Thin JDBC driver

When Implicit Connection Cache is used in a RAC environment and there are load peaks where all connections are used, then the load in the application reduces and the ICC is using the same number of connections as before and they are not released.
The connections are used very frequent and the InactivityTimeout  is necer reached for any connection as the usage rate is more frequent than the InactivityTimeout timeout.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms