AS Console Shows more Connections in the Database than Configured for the Datasource
(Doc ID 414478.1)
Last updated on OCTOBER 19, 2018
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"
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.|