Re: Tuning question....

Ender.

iowait is not bad. It just means that there is nothing else the CPU can do. So if you would have more processes (workload) on the CPU the iowait would dissapear or would be less.

The thing to look at is v$system_event. Make sure that timed_statistics is enabled and you can see where you spend your time waiting.

You can also upload an report.txt file to http://www.oraperf.com, it will tell you if there is an I/O problem and what file is causing it.

Anjo.

EnderW wrote:

> Hi,
> I am probably not gonna get any reply but I should do this on general
> principles anyway. I am using the "top" command on a machine and am
> seeing 61% iowait. Now in terms machine is a Solaris 2.7 E4500. Is this
> usual ? I have an oracle instance on the machine. I am trying to tune
> it and I have started from system level to see if there is anything I
> can improve. Seems like 61% iowait seems a little high to me. It is
> probably coming from contention from disks. Question is, is this value
> normal for iowait or not ? Thnx...
>
> PS. Better be that group, I don't think sys. adm. are into tuning...
>
> --
> Ender Wiggin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jun 24 2000 - 00:00:00 CDT