How to Check if a Purge Candidate Instance has a Component in Running State

(Doc ID 1573058.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


WARNING: This is an intensive sql query and could therefore effect the performance on the system while this query is running. 
It is recommended to run these scripts outside of normal business hours, and also limit the time-window configured on the query.


This query is doing a verification to detect something anomalous in the tables. The first two columns represent the state of the composites instances (purgeable states) and the right columns represent associated components that are in a running state.

Using this query you will be able to detect those composite instances that despite having a completed states in the composite_instance table, are not purged, meaning that there could be running components for the same ECID in bpel - mediator - dlvmessage - rules - hw. 

The below query is doing a comparison between the:

(ENDING STATES from composite_instance ) v/s RUNNING STATES in other components.


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