-- Sessions Count from History 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 rl.resource_name = 'sessions' and S.BEGIN_INTERVAL_TIME>=to_date('20170312','YYYYMMDD') and S.END_INTERVAL_TIME<=to_date('20170314','YYYYMMDD') ORDER BY s.begin_interval_time, rl.instance_number;
-- Processes Count from History 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 rl.resource_name = 'processes' and S.BEGIN_INTERVAL_TIME>=to_date('20170312','YYYYMMDD') and S.END_INTERVAL_TIME<=to_date('20170314','YYYYMMDD') ORDER BY s.begin_interval_time, rl.instance_number;
|