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;
Search This Blog
Total Pageviews
Thursday, 24 February 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment