Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘script to analyze Disk IO’s’

script to analyze Disk IO’s

Posted by Pavan DBA on July 1, 2012


To Analyze the DISK I/o’s

==========================

 

prompt SESSIONS PERFORMING HIGH I/O > 50000

select p.spid, s.sid,s.process cli_process, s.status,t.disk_reads, s.last_call_et/3600 last_call_et_Hrs,
s.action,s.program,lpad(t.sql_text,30) “Last SQL”
from v$session s, v$sqlarea t,v$process p
where s.sql_address =t.address and
s.sql_hash_value =t.hash_value and
p.addr=s.paddr and
t.disk_reads > 10000
order by t.disk_reads desc;

Posted in Performance Tuning, Scripts | Tagged: | Leave a Comment »

 
%d bloggers like this: