Historical growth of resources
set head on
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
select
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
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;
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;
No comments:
Post a Comment