Query to monitor BPEL processes.

The following query can be used to monitor BPEL processes.

select count(1), RTRIM(process_id),
case state when 0 then 'intiated'
when 1 then 'open and running'
when 2 then 'open and suspended'
when 3 then 'open and faulted'
when 4 then 'closed and pending'
when 5 then 'closed and completed'
when 6 then 'closed and faulted'
when 7 then 'closed and canceled'
when 8 then 'closed and aborted'
when 9 then 'closed and stale'

else 'unknown' end as status
from ORABPEL.CUBE_INSTANCE
where trunc(creation_date) >= :B1 and state <> 5
group by process_id, state