Re: oracle is causing high WIO

Are you running statspack on this db?
(level 5 is assumed for top SQL report)

If so, you can run a report and get an idea of which SQL is causing massive IO. You can also see which datafiles are involved in the IO.

If you have monitoring enabled at the table and/or index level, you can also check dba_tab_modifications for IO.

This assumes at least version 9.2 of Oracle.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On 10/24/05, raja rao <raja4list_at_yahoo.com> wrote:
>
> It seems the problem is with oracle.
> Now when I shutdown the WIO is 0% AND when i start oracle, it is showing
> WIO as 80-90%
> $ sar -u 2 4
> SunOS oracle 5.9 Generic_117171-02 sun4u 10/24/2005
> 11:54:39 %usr %sys %wio %idle
> 11:54:41 4 4 85 6
> 11:54:43 1 2 83 14
> 11:54:45 1 2 81 16
> 11:54:47 2 2 82 13
> $
> how to find out why oracle is causing this high WIO ?
> can someone help me
>

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