统计一段时间内的sql_id

--一个时间段SQL_ID执行的次数统计--  12awqv57hgg4a,a0m9rb5mc68zj   ,update t_stl_list--  cq8zn91786g90,59nwtmw2q2ssy   ,delete t_stl_list--  43bscdyp00dqa   ,insert t_h_stl_listselect a.sql_id,        sum(executions_delta) EXECUTIONS,        round(sum(disk_reads_delta) / sum(executions_delta)) disk_reads,        round(sum(buffer_gets_delta) / sum(executions_delta)) buffer_gets,        round(sum(rows_processed_delta) / sum(executions_delta)) rows_processed,        sum(rows_processed_delta) sum_rows_processed_delta,        round(sum(cpu_time_delta) / sum(executions_delta) /1000,3) cpu_time_ms_delta,        round(sum(elapsed_time_delta) / sum(executions_delta)/1000,3) elapsed_time_ms_delta,        min(c.sql_text)  from dba_hist_sqlstat a, dba_hist_snapshot b, v$sqlarea c where a.snap_id = b.snap_id   and a.instance_number = b.instance_number   and a.sql_id = c.sql_id(+)   and b.begin_interval_time >= to_date('2014-01-21 11:14:00','yyyy-mm-dd hh24:mi:ss')   and b.end_interval_time <= to_date('2014-01-21 11:31:00','yyyy-mm-dd hh24:mi:ss')   --and b.begin_interval_time >= sysdate - 60 / 1440   and a.instance_number = 1    --节点   and executions_delta <> 0   --and c.command_type <> 3      --排除SELECT   group by a.sql_id   order by 6 desc;