Find top disk_reads by an user - Oracle Database Script.
SELECT username users,
round(DISK_READS/Executions) DReadsExec,
Executions EXEC,
DISK_READS DReads,
sql_text
FROM gv$sqlarea a,
dba_users b
WHERE a.parsing_user_id = b.user_id
AND Executions > 0
AND DISK_READS > 100000
ORDER BY 2 DESC;