Using JMX to query DbAdapter ConnectionPool and JCA Connection states/statistics - And output statistics only if Reserved Connections are less than a threshold and/or only when number of Reserved Connections change.
Last updated on JANUARY 30, 2018
Applies to:Oracle SOA Suite - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12c]
Information in this document applies to any platform.
The following document outlines how to setup the BPEL -> DB Adapter testcase that was used to test this program and load the Db Adapter connection pool:
The following doc outlines the setup and running of a JMX program:
Then the following document shows how to query DB Adapter connection pool values:
Then the following document added logic to print out only under certain conditions to more finely target collection.
Document : 2354466.1 - Using JMX to query DbAdapter ConnectionPool values - Then output statistics only if Reserved Connections are less than a threshold and/or only when Reserved Connections changes.
Here in this document a list of JCA Connections are printed along with their associated attributes:
The MBean used here is:
MBean Name com.bea:Name=eis/DB/scottconnection,ServerRuntime=soa_server1,Location=soa_server1,Type=ConnectorConnectionPoolRuntime,ApplicationRuntime=DbAdapter,ConnectorComponentRuntime=DbAdapter
This bean contains the info for Each Connection:
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