Hi

I need to know what all sql's ran during certain period of time.

Assuming my statspacksnapshot is of 15 minute interval.I write this script

Code:
select
   to_char(snap_time,'mm/dd/yyyy hh24:mi:ss') ,
   rows_processed                         num_rows,
   sql_text
from
   perfstat.stats$sql_summary sql_summary,
   perfstat.stats$snapshot     snap
where
   sql_summary.snap_id in
   (select snap_id
           from perfstat.stats$snapshot
           where snap_time between to_date('12/09/2006 19:00:00','MM/DD/YYYY HH24:MI:SS')
           and  to_date('12/09/2006 19:41:00','MM/DD/YYYY HH24:MI:SS')
   )
and
sql_summary.snap_id = snap.snap_id
Will this script give me the correct answer for all the sql's that ran during the period of time ?

Is my script right ?

regards
Hrishy