Yanfeng's life and thought
Tuesday, February 12, 2013
find out longest running sql statement
select * from
(select sql_text,
rank() over ( order by buffer_gets desc ) as rank_bufgets,
to_char(100 * ratio_to_report(buffer_gets) over (), '999.99') pct_bufgets
from V$sql )
where rank_bufgets < 11;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment