Tag Archives: writes

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# ;