Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hardware tips
<denevge_at_my-deja.com> skrev i melding news:915c10$cp8$1_at_nnrp1.deja.com...
> waiting for i/o indicates that a process that has reserved the cpu is
> waiting for the response of an I/O operation.
> On a single-cpu machine this can cause the machine to "virtually hang"
> because the process that's been executing has the cpu reserved and is
> just waiting.
>
> Normally it can happen from time to time you have a peak of 90+, but if
> it returns at a regular interval, then you have a problem.
> try to backtrace what is causing the I/O. (eg. full table scan on big
> row ??? )
>
> Maybe it's usefull in your case to gatherer the statistics a whole day
> long. ( with interval 10 sec )
> then you will soon see if the "waiting for I/O" problem is indeed
> blocking your cpu.
Thanks, I'll try that.
> your vmstat seems to be OK, but here the same remark, do a vmstat
> during a whole day.
>
> Analyse the data. try to make correlations between high cpu-usage ( or
> high waiting for i/o ) and certain procedure, programs that have been
> runnning on the system.
>
> Hope this helps
> Gert
I hope so too.
Sindre Received on Wed Dec 13 2000 - 01:57:37 CST