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.

(Doc ID 2354466.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle SOA Suite - Version 12.2.1.0.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Goal

The following doc outlines the setup and running of a JMX program:

Using JMX to query and execute SOA/Weblogic MBeans to diagnose and monitor SOA problems or automate SOA solutions (Doc ID 2275890.1)

Then the following document shows how to query DB Adapter connection pool values:

Document : 2354398.1 - Using JMX to query DbAdapter ConnectionPool 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:

How to set up a BPEL Composite that executes a PL/SQL Stored Procedure through JCA DB Adapter and simulate timeouts. (Doc ID 2352593.1)

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
Description

This class is used for monitoring a WebLogic Connector Connection Pool

 

Solution

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