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

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

   <source lang="sql">

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></source>