Data is stored somewhere

Oracle :: Disk I/O, Events, Waits

—

by

bsingh@yahoo.com
in

nnnnn

Datafile I/O

DATAFILE I/O NOTES:

  • File Name – Datafile name
  • Physical Reads – Number of physical reads
  • Reads % – Percentage of physical reads

  • Physical Writes – Number of physical writes
  • Writes % – Percentage of physical writes
  • Total Block I/O’s – Number of I/O blocks

  • Use this report to identify any “hot spots” or I/O contention
    • select  NAME,
    PHYRDS "Physical Reads",
    round((PHYRDS / PD.PHYS_READS)*100,2) "Read %",
    PHYWRTS "Physical Writes",
    round(PHYWRTS * 100 / PD.PHYS_WRTS,2) "Write %",
    fs.PHYBLKRD+FS.PHYBLKWRT "Total Block I/O's"
    from (
    select  sum(PHYRDS) PHYS_READS,
    sum(PHYWRTS) PHYS_WRTS
    from   v$filestat
    ) pd,
    v$datafile df,
    v$filestat fs
    where  df.FILE# = fs.FILE#
    order  by fs.PHYBLKRD+fs.PHYBLKWRT desc

    Comments

    Leave a Reply

    Your email address will not be published. Required fields are marked *