If you run Oracle SOA BPEL on-premise and at scale, you know how easier it can be to monitor your SOA BPEL processes through SQL queries. Those SQL queries get more profitable the more SOA BPEL instances you get, as the Enterprise Manager console usually doesn’t work for big payloads. You’ll find below a couple of SQL queries to :
- Identify BPEL Errors from the last 10 minutes
- Identify Business faults from the previous 10 minutes
- Identify instance not purged after the retention period (here 70 days)
- Get the number of process and their states for each composite name and revision (useful to identify composites due to be undeployed)
- Multiple SQL queries to monitor the database size
- Get the list of composite, revision, and date of their last instances
If the queries you’re looking for aren’t here, take a look at this second article on the matter : SQL Queries to debug Oracle SOA BPEL