AS Console Shows more Connections in the Database than Configured for the Datasource (Doc ID 414478.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for iAS - Version: 10.1.2.0.2
This problem can occur on any platform.

Symptoms

AS Console JDBC metrics are not consistent with actual opened connections in the database.

After some tests V$SESSION shows 1 open connection, which was open from a data-source using pooling  while AS Console JDBC usage report 3 opened connections.

Settings for the data-source regarding pool of connections was : min-connections=1 max-connections=2

Metrics referenced are the ones displayed when an OC4J is select from the list of AS components:

"Open JDBC Connections" and "Total JDBC Connections"   



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