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

最新推荐文章于 2024-07-18 21:24:26 发布

weixin_30762087

最新推荐文章于 2024-07-18 21:24:26 发布

阅读量536

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/ss-33/p/10791688.html

版权

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;