Re: high WIO on solaris

Solaris 9 doesn't offer you that much help. But if you google a bit you can find tools helping you to list i/o-consumption per process (pio, topio for instance). Much easier in Solaris 10 with DTrace.

But if Oracle is the only software running on your host, it does give you much more accurate information than any other OS-tool out there.

Why not start monitoring v$sql, v$sess_io, v$filestat?

/Kristian

> Hi All,
>
>
> I am using oralce 9i on Solaris 9. Today our server responded slowly and
> when we checked cpu usage using sar
> (sar -u 2 4 )
>
> we observed high WIO.
>
> $ sar -u 2 4
> SunOS oracle 5.9 Generic_117171-02 sun4u 10/17/2005
> 09:42:14 %usr %sys %wio %idle
> 09:42:16 0 1 88 10
> 09:42:18 0 1 86 13
> 09:42:20 0 1 88 11
> 09:42:22 7 7 75 10
>
>
> I checked the high cpu consuming processes using ps -eaf. Surprisingly
> there is no
> single session using high cpu.
>
> How to find out which process is causing this high WIO.
>
> Can somebody help us. This is causing lot of troubles to us.
>
> Thanks in advance,
> Raj
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

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