Re: AWR Sample Report

From: raja <dextersunil_at_gmail.com>
Date: Fri, 12 Dec 2008 04:39:27 -0800 (PST)
Message-ID: <f61ffa10-1f2d-49d2-ba40-11de7878a453@w24g2000prd.googlegroups.com>

Hi Charles/ Steeve,

Query 1 ( Query given by charles ) :
select
  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 1, 2;

The output of your query is present in excel file named as : wait1

Query 2 ( Query given by steeve ) :
select * from (
select event_name, wait_class,to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),

       dhse.instance_number,
       time_waited_micro - lag(time_waited_micro, 1, 0) over (order by
dhse.instance_number, dhse.snap_id) as time_waited,
       total_waits - lag(total_waits, 1, 0) over (order by
dhse.instance_number, dhse.snap_id) 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   and begin_interval_time > sysdate - num_of_days_to_analyze order by 5 desc)
where rownum < 10000;

The output of your query is present in excel file named as : wait2 Here, the wait event : "PX qref latch" tops the list

Since i am not able to post those files in our group's thread, i am sending those files to ur mail ids.
Please check these 2 files and tell me your observations. Also, another doubt is : whether should be neglect the idle events always ? then why are they notified to us...

With Regards,
Raja. Received on Fri Dec 12 2008 - 06:39:27 CST