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
/
Published by
on
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