oracle中通过v$sql视图查询最糟糕的查询

select * from (

         select address,rank() over (order by buffer_getsdesc) as rank_bufgets,

          to_char(100*ratio_to_report(buffer_gets) over(),'999.99')  pct_bufgets

           from v$sql

)  

where rank_bufgets < 11;

 

查询SQL语句的内容：

col sql_text for A50

select * from (

         select sql_text,rank() over (order by buffer_getsdesc) as rank_bufgets,

          to_char(100*ratio_to_report(buffer_gets) over(),'999.99')  pct_bufgets

           from v$sql

)  

where rank_bufgets < 11;