AS Console Shows more Connections in the Database than Configured for the Datasource
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.
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"
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