select *
from v$sqlarea v
where executions > 0
and buffer_gets > 0
and (buffer_gets - disk_reads) / buffer_gets < 0.8
order by v.user_io_wait_time desc
select executions,
disk_reads,
buffer_gets,
round((buffer_gets - disk_reads) / buffer_gets, 2) hit_radio,
round(disk_reads / executions, 2) reads_per_run,
sql_text
from v$sqlarea v
where v.parsing_schema_name = 'juqi'
and executions > 0
and buffer_gets > 0
and (buffer_gets - disk_reads) / buffer_gets < 0.8
order by 4 desc
from v$sqlarea v
where executions > 0
and buffer_gets > 0
and (buffer_gets - disk_reads) / buffer_gets < 0.8
order by v.user_io_wait_time desc
select executions,
disk_reads,
buffer_gets,
round((buffer_gets - disk_reads) / buffer_gets, 2) hit_radio,
round(disk_reads / executions, 2) reads_per_run,
sql_text
from v$sqlarea v
where v.parsing_schema_name = 'juqi'
and executions > 0
and buffer_gets > 0
and (buffer_gets - disk_reads) / buffer_gets < 0.8
order by 4 desc