RE: can I measure IO per process?

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Henry Poras Sent: Tuesday, February 14, 2006 7:44 AM To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l