We are using UCP 11g R3 with Tomact 6. We have configured SiteScope to monitor UCP's borrowedConnectionCount through JMX.
One problem that we are facing is that the MBean object name is dynamically changing on every JVM recycle.
The MBean name listed under oracle.ucp.admin.UniversalConnectionPoolMBean is in this format,
The number 7745766443905610782 is dynamic on every JVM recycle. So we have to change MBean name every time in SiteScope.
Here is the datasource configuration,
. . .
sqlForValidateConnection="select 1 from DUAL"
Is there any configuration to set this MBean name?