List top SQL statements in Oracle

The script will identify top SQL statements.

col mod         heading 'Stmt Addr'            format          a18
col dr          heading 'Disk Rds'              format  999,999,999
col bg          heading 'Buff Gets'             format  999,999,999
col sr          heading 'Sorts'                 format       99,999
col exe         heading 'Runs'                  format      99,999,999
col loads       heading 'Body Loads'            format       99,999
col load        heading 'Load Factor'           format      999,999


select
  a.address                       mod,
  a.disk_reads                    dr,
  a.buffer_gets                   bg,
  a.sorts                         sr,
  a.executions                    exe,
  a.loads                         loads,
  (a.disk_reads*100+a.buffer_gets)/1000   load
from
  v$sqlarea a
where
  a.disk_reads   > &min_dr and
  a.buffer_gets  > &min_bg
order by
  a.disk_reads*100+a.buffer_gets desc
/