dba_hist_sqlstat elapsted_time_delta
Does anyone know why the elapsed_time_delta for a particular
sql_id would be greater than the interval between snapshots.
The executions_delta is 0, the snapshots are every 10 minutes, yet the elapsed_time_delta is about 50 minutes.
1 SELECT a.snap_id,
2 to_char(begin_interval_time,'MM/DD/YYYY HH24:MI') snap_time,
3 executions_delta,
4 round(elapsed_time_delta/1000000/60/greatest(executions_delta,1)) et
5 FROM DBA_HIST_SQLSTAT a, DBA_HIST_SNAPSHOT b
6 WHERE a.snap_id = b.snap_id
7 and sql_id='0va4j22vqwhzh'
8 and begin_interval_time between to_date('09/24/2010 10:40')
9 and to_date('09/24/2010 11:40')
The executions_delta is 0, the snapshots are every 10 minutes, yet the elapsed_time_delta is about 50 minutes.
1 SELECT a.snap_id,
2 to_char(begin_interval_time,'MM/DD/YYYY HH24:MI') snap_time,
3 executions_delta,
4 round(elapsed_time_delta/1000000/60/greatest(executions_delta,1)) et
5 FROM DBA_HIST_SQLSTAT a, DBA_HIST_SNAPSHOT b
6 WHERE a.snap_id = b.snap_id
7 and sql_id='0va4j22vqwhzh'
8 and begin_interval_time between to_date('09/24/2010 10:40')
9 and to_date('09/24/2010 11:40')
0