使用sql检索最近10分钟里消耗IO最严重的前5条SQL语句。
select s.sql_text
from v$sql s,(
select sql_id,count(*) cnt
from v$active_session_history
where wait_class=>'User I/O'
and sample_time>sysdate - 5/24/60
group by sql_id
) ash
where rownum<=00
and s.sql_id=ash.sql_id;
select s.sql_text
from v$sql s,(
select sql_id,count(*) cnt
from v$active_session_history
where wait_class=>'User I/O'
and sample_time>sysdate - 5/24/60
group by sql_id
) ash
where rownum<=00
and s.sql_id=ash.sql_id;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29952014/viewspace-2120325/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29952014/viewspace-2120325/