Buffer intensive queries


select  EXECUTIONS,
BUFFER_GETS,
round(DISK_READS / decode(EXECUTIONS, 0, 1, EXECUTIONS) / 400,2) "Gets/Execs",
SQL_TEXT
from   v$sqlarea
where    BUFFER_GETS / decode(EXECUTIONS,0,1, EXECUTIONS) / 400 > 10
order    by EXECUTIONS desc

 

Leave a Reply

Your email address will not be published. Required fields are marked *