select b.username, a.disk_reads, a.executions, a.sql_text
from v$sqlarea a, dba_users b
where a.disk_reads > 100000
and a.parsing_user_id = b.user_id
order by a.disk_reads
/

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.