Search This Blog

Total Pageviews

Thursday 24 February 2011

How many Times a query executed ?

select s.begin_interval_time, sql.sql_id as sql_id, sql.executions_delta as exe_delta, sql.EXECUTIONS_TOTAL
from dba_hist_sqlstat sql, dba_hist_snapshot s
where sql_id='cvhk2j2gymzhd'
and s.snap_id = SQL.snap_id
and s.begin_interval_time> TO_date('18-feb-2011 1:00', 'dd-mon-yyyy hh24:mi')
and s.begin_interval_time< TO_date('18-feb-2011 2:30', 'dd-mon-yyyy hh24:mi') order by s.begin_interval_time;

No comments:

Oracle DBA

anuj blog Archive