Oracle 查询SQL 执行次数---hash value

col BEGIN_INTERVAL_TIME for a25 \r
col END_INTERVAL_TIME for a25 \r
col instance_number for 99 \r
set linesize 1000 pagesize 999 \r
select a.snap_id,
a.sql_id,
a.instance_number,
b.BEGIN_INTERVAL_TIME,
b.END_INTERVAL_TIME ,
a.EXECUTIONS_DELTA,
a.plan_hash_value,
a.CPU_TIME_DELTA
from wrh$_sqlstat a, wrm$_snapshot b
where a.snap_id = b.snap_id
and a.instance_number = b.instance_number
and a.sql_id = '&sql_id'
order by 4, 1, 3;