Oracle 查看当前执行IO次数最多的SQL

--查询当前执行IO最多的sql,并按大到小来排序
select cast(buffer_gets/decode(EXECUTions,0,10000,EXECUTions) as int) 平均IO ,
EXECUTions 执行次数,buffer_gets 总逻辑IO,disk_reads 硬盘读取,
sql_text SQl语句 from v$sqlarea
where parsing_schema_name='HQT'
order by buffer_gets desc
posted @   zping  阅读(5195)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示