Monthly Archives: February 2013

Show Oracle Reads And Writes By File Name In Oracle Database

Oracle can show us the reads and writes by datafile name.   This is done by stats kept ini v$filestat

 

set lines 200
set pages 200
select v$datafile.name "File Name", v$filestat.phyrds "Reads", v$filestat.phywrts "Writes" from v$filestat,v$datafile where v$filestat.file# = v$datafile.file# ;