Oracle PL/SQL Tutorial/System Tables Data Dictionary/V DATAFILE

30. I/O (expressed in database blocks) by datafile

SQL>
SQL> select DF.Name File_Name,
  2         FS.Phyblkrd Blocks_Read,
  3         FS.Phyblkwrt Blocks_Written,
  4         FS.Phyblkrd+FS.Phyblkwrt Total_IOs
  5    from V$FILESTAT FS, V$DATAFILE DF
  6   where DF.File#=FS.File#
  7   order by FS.Phyblkrd+FS.Phyblkwrt desc;

FILE_NAME
------------------------------------------------------
BLOCKS_READ  BLOCKS_WRITTEN   TOTAL_IOS
-----------  --------------  ----------
C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
       4954             405        5359
C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
       2294             398        2692
C:\ORACLEXE\ORADATA\XE\UNDO.DBF
       1219            1422        2641
C:\ORACLEXE\ORADATA\XE\USERS.DBF
          6               3           9
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\
DATA_1B.DBF
          5               2           7
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\
DATA_1A.DBF
          5               2           7


6 rows selected.
SQL>