Historical growth of resource limit

 

Historical growth of resources

set head on  
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
select 

        s.SNAP_ID,BEGIN_INTERVAL_TIME, END_INTERVAL_TIME,RESOURCE_NAME,         CURRENT_UTILIZATION, MAX_UTILIZATION
FROM 

DBA_HIST_RESOURCE_LIMIT S, DBA_HIST_SNAPSHOT SS 
where RESOURCE_NAME IN ( 'sessions', 'processes')
      AND ss.snap_id = S.snap_id
      AND ss.instance_number = S.instance_number
order by s.snap_id;