Top I/O report

I'm looking for a 'top I/O report by process' report. We have a few performance problems on Oracle DB's, so we want to see what db is causing the problem and where the I/O contention is.

Unfortunately the db's are sharing 2 large SSA RAID-10 volumes, so all iostat tells me is 'yea hdisk12 is busy'. I've looked at filemon, fileplace, svmon, tprof. None see to say 'Ok here's your busiest I/O processes, and here's the devices they're performing the I/O on.'

Any suggestions?

ray
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Ray DeJean http://www.r-a-y.org
Systems Engineer Southeastern Louisiana University
IBM Certified Specialist AIX Administration, AIX Support
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Relevant Pages

  • Re: Top I/O report
    ... I'm looking for a 'top I/O report by process' report. ... We have a few performance problems on Oracle DB's, so we want to see what db is causing the problem and where the I/O contention is. ... None see to say 'Ok here's your busiest I/O processes, and here's the devices they're performing the I/O on.' ...
    (AIX-L)
  • Re: Top I/O report
    ... You can also use svmon to pull LV's that are being touched ... I'm looking for a 'top I/O report by process' report. ... performance problems on Oracle DB's, so we want to see what db is causing ...
    (AIX-L)
  • Re: CPU waiting for... what? (mistery)
    ... > size of the Oracle buffer cache. ... iostat command) gets about tenfold. ... Thank you for your explanation about the steps Oracle uses in this ... > A VERY large fraction of it is single block I/O. ...
    (comp.unix.solaris)
  • Re: ra_pages and io rate
    ... -asyn I/O package source) but constantly deliver a high load ... -the cache of the I/O subsystem - on average, ... Two of the oracle systems which i am ... data from the disks, the ...
    (comp.databases.informix)
  • Re: List of running processes in C++
    ...  The CPU usage is usually negligible. ... Which basically means that oracle does the writing for you, ... process's I/O bandwidth is controlled by oracle's I/O bandwidth. ...
    (comp.unix.programmer)