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.
Last updated on JANUARY 29, 2018
Applies to:Oracle SOA Suite - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 12c]
Information in this document applies to any platform.
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:
Here in this document we add logic to print out database connection pool statistics only if Reserved Connections are less than a threshold and/or only when Reserved Connections changes. This is an example of the type of logic one can add to gather information more precisely .The statistics are polled every 20 seconds but this can be easily changed.
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 MBean used here is:
This class is used for monitoring a WebLogic Connector Connection Pool
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