My Oracle Support Banner

How to Check if a Purge Candidate Instance has a Component in Running State (Doc ID 1573058.1)

Last updated on JULY 10, 2020

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.