How to find out number of BPEL instances in SOA 11g dehydration store?

A common task for fusion admins would be to find out the number of BPEL instances in the SOA dehydration store,the SOA database. Basically this information is stored in a table called COMPOSITE_INSTANCE and the owner of the table id DEV_SOAINFRA schema.

There are two major ways of doing it:

1. From EM Console

For finding out the instance count from EM console:

a. Login to the SOA 11g EM console and expand the SOA folder on your left.This is shown below. Click on the soa-infra

b. On the right hand side of the screen click on Number of Instances as shown below:

c. The number of instances is displayed as shown below:

2. Select query on SOA dehydration table

 For finding out the number of BPEL instances in your SOA 11g Dehydration using SQL query follow  below steps:

a. Login to the SOA 11g Database using a SQL Client as DEV_SOAINFRA user.(Check out if your prefix ie DEV here is different)

b. Issue below command:

select count(*) from COMPOSITE_INSTANCE;

That would give you the number of instance present in the SOA dehydration store :)

Number of Instances for a specific Composite:


What if you wanted to find the number of instance for each composite,well use the below query

select count(*) from composite_instance where source_name='Composite Name'

More to follow on how to find the performance......

How to disable BAM sensors from EM console

We can disable publishing sensors to BAM (Business Activity Monitoring) servers from any particular SOA composites or completely from SOA server to BAM server.

For example, if there is any issues in BAM servers and you want to stop publishing sensors to BAM temporarily, you can disable it from EM console as given below.

Note: Even though it is said that there is no performance impact in publishing multiple sensors for BAM server from SOA composite, under load there is a slight performance impact. Hence it is always advisable to keep minimum sensors from SCA.

Disable BAM Sensor data publishing completely from all the composites

      1. Login into EM Console
      2. Expand SOA , Right Clik soa-infra, select SOA Administration and Click on BPEL Properties

      3. Check Disable BPEL Monitors and Sensors option to disable the sensor.
 

Disable BAM Sensor From EM Console

 
Disable BAM Sensor data publishing from particular Composite

       1. Select particular composite
       2. Select Settings –> Click on Enable/Disable Business Monitoring..
       3. Choose Disable All to disable sensor for particular composite.