| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: CPU at 100%
Hi
About your question in Oracle Group :
Look, almost 50% of the cpu's work time is related with disk i/o, so you
must to check
how much disk activity are there in your plattform. If you find a high
level disk activity maybe your Oracle SGA is a little small, in this
case you must to increase the parameter shared_pool_size about 20 or 30%
and try a again.
Hope this help you
Michael Rothwell wrote:
> I have an old system running Oracle 7.2.2 and HPUX 9.4. The
> hardware is old and slow, but lately seems even slower.
> Even when I run a query against the data dictionary to view
> a list of indexes, it takes 25 to 30 seconds to return a
> list of 81 indexes. Whenever a query is run, the CPU pegs
> it'self to 100% and stays there for much too long for the
> type of query being run.
>
> Does anyone know what I should be looking for?
>
> Michael.
>
--
"Smell the Flower While you can"
 |
 |