DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Friday, April 17, 2015

Query to see the top 10 io datafiles for write activity

select * from (
select substr(,8,(instr(,'/',9,1) -8)) fsmtpt,
substr(,(instr(,'/',-1,1)+1)) fname,
s.phyrds, s.phywrts,s.lstiotim,s.avgiotim
from v$datafile f, v$filestat s
where f.file# = s.file#
order by 4 desc)
where rownum < 11;

No comments: