Re: AWR Sample Report

Hi,

Kindly check the attached excel sheet.
Since i am not able to post here, i am sending the output to your mail id.

Query :
select
  dhse.event_name,
  to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),   dhse.instance_number,
  time_waited_micro - nvl(lag(time_waited_micro, 1, 0) over (partition by dhse.instance_number, dhse.event_name order by dhse.snap_id),0) as time_waited,
  total_waits - nvl(lag(total_waits, 1, 0) over (partition by dhse.instance_number, dhse.event_name order by dhse.snap_id),0) as total_waits
from dba_hist_snapshot dhs, dba_hist_system_event dhse where dhs.snap_id = dhse.snap_id
  and dhs.instance_number = dhse.instance_number order by 2, 4;

Kindly provide me your suggestions.

With Regards,
Raja. Received on Fri Dec 19 2008 - 05:17:20 CST