Statistics of gets


select  USERNAME,
CONSISTENT_GETS,
BLOCK_GETS,
PHYSICAL_READS,
((CONSISTENT_GETS+BLOCK_GETS-PHYSICAL_READS) / (CONSISTENT_GETS+BLOCK_GETS)) Ratio
from   v$session ses, v$sess_io, (select distinct sid from v$mystat) mses
where   ses.SID = v$sess_io.SID
and   (CONSISTENT_GETS+BLOCK_GETS) > 0
and   USERNAME is not null  and mses.sid = ses.SID
order  by ((CONSISTENT_GETS+BLOCK_GETS-PHYSICAL_READS) / (CONSISTENT_GETS+BLOCK_GETS))

 

Leave a Reply

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