Resource utilization

August 29th, 2013

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
/


Comments are closed.