Logo Background

Oracle I/O Monitoring Script

  • By on August 22, 2008 | No Comments

    The script as below can be used to monitor the Oracle data files I/O. You may need to plan for data file redistribution if most of the I/O goes to the same physical mount point.

    DB IO Monitoring

    SELECT vfs.file#, dbf.file_name, dbf.tablespace_name, dbf.bytes, vfs.phyrds/vfs.phywrts,
    vfs.phyblkrd/vfs.phyblkwrt, vfs.readtim, vfs.writetim f
    rom V$FILESTAT vfs, DBA_DATA_FILES dbf
    WHERE vfs.file# = dbf.file_id
    » Analyze, Repair And Optimize MySQL Database
Leave a Comment