Find Top Disk reads for a User in Oracle
Script will list the sessions for a User that go over the 100000 disk_reads value.
select username users, round(DISK_READS/Executions) DReadsExec,Executions Exec, DISK_READS DReads,sql_text
from sys.v_$sqlarea a, dba_users b
where a.parsing_user_id = b.user_id
--and Executions < 4
and b.username like upper('%&user_name%')
-- and BUFFER_GETS > 1000000
and Executions > 0
and DISK_READS > 100000
order by 2 desc;
