Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

IO (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>