Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hardware tips

Re: Hardware tips

From: Sindre Solem <sindre.solem_at_emmaedb.no>
Date: Wed, 13 Dec 2000 08:57:37 +0100
Message-ID: <QZFZ5.135$Ee.992@news1.oke.nextra.no>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US