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;
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;