select substr(to_char(s.pct,'99.00'),)||'%'load,

       s.executions executes,

       p.sql_text

from(select address,

               disk_reads,

               executions,

               pct,

               rank()over(order by disk_reads desc) ranking

         from(select address,

                       disk_reads,

                       executions,

                      *ratio_to_report(disk_reads)over() pct

                 from sys.v_$sql

                where command_type!=)

        where disk_reads>*executions) s,

       sys.v_$sqltext p

where s.ranking<=

  and p.address=s.address

order by , s.address, p.piece;

select b.username,

       a. buffer_gets,

       a.executions,

       a.disk_reads / decode(a.executions, , , a.executions),

       a.sql_text SQL

  from v$sqlarea a, dba_users b

 where a.parsing_user_id = b.user_id

   and a.disk_reads >

 order by disk_reads desc;

select*

from(select buffer_gets, sql_text

         from v$sqlarea

        where buffer_gets>

        order by buffer_gets desc)

where rownum<=;

select sql_text, executions

  from (select sql_text, executions from v$sqlarea order by executions desc)

 where rownum < ;

select sql_text, disk_reads

from(select sql_text, disk_reads from v$sqlarea order by disk_reads desc)

where rownum<;

select sql_text, sorts

from(select sql_text, sorts from v$sqlarea order by sorts desc)

where rownum<;

select substr(sql_text, , ) "sql", count(*), sum(executions) "totexecs"

  from v$sqlarea

 where executions <

 group by substr(sql_text, , )

having count(*) >

 order by ;