RE: can I measure IO per process?

  • From: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
  • To: <henry@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 14 Feb 2006 08:02:14 -0800

Just a thought, are you using dedicated server processes? If so, what
about monitoring v$sess_io and maybe v$session_wait?
 

Thanks! 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Henry Poras
Sent: Tuesday, February 14, 2006 7:44 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: can I measure IO per process?



I'm currently running on RedHat AS3. On one of our boxes I noticed the
CPU was spending most of its time with 'wait io' (wa column in vmstat
was 85%-95%). The servicetime as seen from iostat -dk -x was also high,
so this was a problem. What I couldn't figure out, and what would be
very useful, was how to associate the io with specific processes. Is
there a way to do this?

Thanks. 

Henry 

Other related posts: