Monday, June 29, 2015

View SQL that run more than one hour from AWR views

select  sql_text 

from    dba_hist_sqltext 
where   sql_id in 
  (select   sql_id
   from     dba_hist_sqlstat 
   where    snap_id between &Start_SnapID and &End_SnapID
   and      elapsed_time_total > 7200000000 -- number for 1 hour
)
/

No comments:

Post a Comment