Resource utilization



Resource utilization history


select to_char(BEGIN_INTERVAL_TIME,'dd-mm-yyyy HH24:MI'), to_char(END_INTERVAL_TIME,'dd-mm-yyyy HH24:MI'), 
	ss.SNAP_ID, l.CURRENT_UTILIZATION, l.MAX_UTILIZATION from DBA_HIST_RESOURCE_LIMIT l, DBA_HIST_SNAPSHOT ss
	where ss.SNAP_ID = l.SNAP_ID
	and upper(l.RESOURCE_NAME) like upper('%&resource_name%')
	order by BEGIN_INTERVAL_TIME
/

<br />
select to_char(BEGIN_INTERVAL_TIME,'dd-mm-yyyy HH24:MI'), to_char(END_INTERVAL_TIME,'dd-mm-yyyy HH24:MI'),<br />
	ss.SNAP_ID, l.CURRENT_UTILIZATION, l.MAX_UTILIZATION from DBA_HIST_RESOURCE_LIMIT l, DBA_HIST_SNAPSHOT ss<br />
	where ss.SNAP_ID = l.SNAP_ID<br />
	and upper(l.RESOURCE_NAME) like upper('%&resource_name%')<br />
	order by BEGIN_INTERVAL_TIME<br />
/<br />