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,
a.CPU_TIME,
a.ROWS_PROCESSED
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 *