[오라클] [스크립트] PROCESS 이력

-- 히스토리에서 프로세스 카운트 확인 
SELECT   rl.snap_id, s.begin_interval_time, s.end_interval_time,
         rl.instance_number, rl.resource_name, rl.current_utilization,
         rl.max_utilization
    FROM dba_hist_resource_limit rl, dba_hist_snapshot s
   WHERE s.snap_id = rl.snap_id 
   and s.instance_number = rl.instance_number
   AND rl.resource_name = 'processes'
   and S.BEGIN_INTERVAL_TIME>=sysdate-1
   and S.END_INTERVAL_TIME<=sysdate
ORDER BY s.begin_interval_time, rl.instance_number;