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
/