set pagesize 60
set linesize 140
col reads_per_exec format 99999999 heading "Reads Per Exec"
col disk_reads format 99999999 heading "Disk Reads"
col executions format 999999999 heading "Executions"
col sql_text format a70 heading "Sql Text"
select cast(disk_reads/(executions+1) as integer) as reads_per_exec,disk_reads,executions,sql_text
from V$SQLAREA where disk_reads/(executions+1) > 1 and executions > 1
and rownum<10
order by disk_reads/(executions+1) desc;
set linesize 140
col reads_per_exec format 99999999 heading "Reads Per Exec"
col disk_reads format 99999999 heading "Disk Reads"
col executions format 999999999 heading "Executions"
col sql_text format a70 heading "Sql Text"
select cast(disk_reads/(executions+1) as integer) as reads_per_exec,disk_reads,executions,sql_text
from V$SQLAREA where disk_reads/(executions+1) > 1 and executions > 1
and rownum<10
order by disk_reads/(executions+1) desc;
Comments