Statistics of reads / writes per session


select  nvl(ses.USERNAME,'ORACLE PROC') username,
OSUSER os_user,
PROCESS pid,
ses.SID sid,
SERIAL#,
PHYSICAL_READS,
BLOCK_GETS,
CONSISTENT_GETS,
BLOCK_CHANGES,
CONSISTENT_CHANGES
from  v$session ses,
v$sess_io sio, (select distinct sid from v$mystat) mses
where   ses.SID = sio.SID and mses.sid = ses.SID
order   by PHYSICAL_READS, ses.USERNAME

 

Leave a Reply

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