RE: Oracle uses 100% CPU

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <vitalisman@xxxxxxxxx>, <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>
  • Date: Tue, 16 Aug 2005 09:53:54 -0400

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Vitalis Jerome
Sent: Tuesday, August 16, 2005 9:43 AM
To: Foelz.Frank@xxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx> 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 <
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: