I/O (expressed in database blocks) by datafile : V_DATAFILE « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. V_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>