Cube_Instance monitoring

select TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') time,process_id, NVL(Complete,'0') "COMPLETE",NVL(Failed,'0') "FAILED",NVL(Running,'0') "RUNNING" from
(select  process_id
 ,       sum(case when state = '5' then 1 end) as Complete
 ,       sum(case when state = '6' then 1 when state='3' then 1 end) as Failed
 ,       sum(case when state = '1' then 1 end) as Running
  from    ORABPEL.cube_instance where process_id in ('QueryServiceUsageListPortalProvABCSImpl','OnlineProcessPaymentEBF','PaymentEBF')
group by process_id)