TOPSQL查询

select rownum as rank, a.*
from (
   select elapsed_Time,
       executions,
       buffer_gets,
       disk_reads,
       cpu_time
       hash_value,
      sql_text
   from  v$sqlarea
   where elapsed_time > 20000
   order by elapsed_time desc) a
where rownum < 11