Oracle查看某天sql执行次数

select a.sql_id,
       to_char(b.begin_interval_time, 'yyyy-mm-dd') "date",
       sum(a.executions_delta) exec_0629
  from dba_hist_sqlstat a, dba_hist_snapshot b
where a.snap_id = b.snap_id
   and a.dbid = b.dbid
   and a.instance_number = b.instance_number
   and a.instance_number = 2
   and to_char(b.begin_interval_time, 'yyyy-mm-dd') = '2011-06-29'
group by a.sql_id, to_char(b.begin_interval_time, 'yyyy-mm-dd')
order by a.sql_id;