📋Steps in this guide1/1

Find top disk_reads by an user

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;

oracle configurationintermediate

by OracleDba

11 views

Find top disk_reads by an user

Code/Command (click line numbers to comment):

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;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!