News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script – Monitor sessions with high Physical Reads

  • Posted by Gavin Soorma
  • On July 1, 2009
  • 0 Comments
set linesize 120
col osuser format a10
col username format 10
select
OSUSER osuser,
username,
PROCESS pid,
ses.SID sid,
SERIAL#,
PHYSICAL_READS,
BLOCK_CHANGES
from v$session ses,
v$sess_io sio
where ses.SID = sio.SID
order by PHYSICAL_READS;
 

0 Comments

Leave Reply

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