RE: Oracle uses 100% CPU

I agree. Unless the server is hung because of 100% cpu, I don't really see a problem. I would investigate for runaway queries to try and determine if anything bad is happening. But 100% utilization in itself is not an indicator of something bad happening.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vitalis Jerome Sent: Tuesday, August 16, 2005 9:43 AM
To: Foelz.Frank_at_scheidt-bachmann.de
Cc: ORACLE-L
Subject: Re: Oracle uses 100% CPU

Hi,

I'm not very knowledgeable on Windows, but why a 100% CPU utilization is of any concern on a server dedicated to Oracle? Is this not what we should expect during peak periods?

On 8/16/05, Foelz.Frank <Foelz.Frank_at_scheidt-bachmann.de> wrote:
> Hi,
>
> what is the recommended DBA way, to determine, what is causing
Oracle.exe to
> consume 100% cpu time ?
> We encounter this once in a while, and all of a sudden around 4am to
5am.
> This affects some of our machines, but not all (and all have the very
same
> configuration) in a 3 to 4 day interval.
>
> Running Oracle 9.2.0.1 on Windows XP
>
> I know that this is a very vague description, but any hint is
appreciated.
>
> Thank you
>
> > Frank <

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