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 /
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 /