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$ "File Name", v$filestat.phyrds "Reads", v$filestat.phywrts "Writes" from v$filestat,v$datafile where v$filestat.file# = v$datafile.file# ;


Leave a Reply

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