Disk reads

Disk reads by selects:

select b.username username,
a.disk_reads reads,
a.executions exec,
round(a.disk_reads / decode(a.executions, 0, 1, a.executions), 2) reads_per_exec,
a.sql_text Statement,
from V$sqlarea a, dba_users b
where a.parsing_user_id = b.user_id
and a.disk_reads > 100000
and a.sql_text like '%...here_your_text....%'
order by a.disk_reads desc;


Leave a Reply

Your email address will not be published. Required fields are marked *