查询执行完的JOB的消耗

查询 PRO_EP_MID_JOB这个执行完的JOB的消耗

select session_id as sid,
       session_serial# as serial#,
       instance_number as inst,
       trunc(cast(sample_time as date), ‘dd’) as sample_time,
       sql_id,
       sql_plan_hash_value as plan_hash_value,
       event,
       program,
       count(distinct snap_id)
  from dba_hist_active_sess_history a
 where session_id in
       (select sid
          from dba_jobs_running
         where job in (select job
                         from dba_jobs  where UPPER(what) like '%PRO_EP_MID_JOB%'))
 group by session_id,
          session_serial#,
          instance_number,
          trunc(cast(sample_time as date), 'dd'),
          sql_id,
          sql_plan_hash_value,
          event,
          program
having(count(distinct snap_id) >= 2)