Re: How do you relate high I/Os waits to a specific file/process ?

On 30 Sep 2003 06:17:23 -0700, spendius_at_muchomail.com (Spendius) wrote:

>Hi,
>I'm often called and told "once again the server
>suffers from high io waits activity, what the hell
>is going on with Oracle again..." etc etc., which
>I can verify with 'top', 'sar' or certain options of
>the 'ps' command as well (I'm talking about io waits
>reaching 40% and more in the '%wio' column of sar for
>example).
>I'd like to know whether it's possible to link this
>IO activity and slowliness with
>-precise files, and/or
>-precise processes
>(in order to see, of course, if they're Oracle related).
>
>It's very easy to link high CPU consumption with a process,
>but not so with io activity, so maybe you can help me please ?
>
>Thanks in advance.
>Spendius

v$system_event, v$session_event, v$sess_io, and v$session_wait come to mind. And of course there is v$filestat to get I/O on datafile basis.

--

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address