统计一条sql_id的信息,详细的运行情况

--一条SQLID的详细运行情况(单条平均)select to_date(to_char(b.end_interval_time, 'yyyy-mm-dd hh24:mi'), 'yyyy-mm-dd hh24:mi') snap_time, a.sql_id,        plan_hash_value,        executions_delta,        round(disk_reads_delta / executions_delta) disk_reads,        round(buffer_gets_delta / executions_delta) buffer_gets,        round(rows_processed_delta/ executions_delta) rows_processed,        rows_processed_delta sum_rows_processed,        round(cpu_time_delta/ executions_delta /1000,3) cpu_time_ms_delta,        round(elapsed_time_delta/ executions_delta/1000,3) elapsed_time_ms_delta  from dba_hist_sqlstat a, dba_hist_snapshot b where a.snap_id = b.snap_id   and a.instance_number = b.instance_number   and a.sql_id = '20ny69pzcgk4z'   --and b.end_interval_time >= sysdate - 6/24   and b.end_interval_time >= to_date('2014-03-24 00:30:00','yyyy-mm-dd hh24:mi:ss')   and b.end_interval_time < to_date('2014-03-24 22:00:00','yyyy-mm-dd hh24:mi:ss')   and a.instance_number = 1   and executions_delta <> 0   order by snap_time desc;