RE: Oracle uses 100% CPU

That is my main intent. Figure out, if there are queries in one of the
applications, that messes up the system.
I have never done this before (I am no DBA, but follow the threads in this
list, regularly), so I need some hints, on where to start and with what.

Thank you for your input

> Frank <


-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx] 
Sent: Tuesday, August 16, 2005 3:54 PM
To: vitalisman@xxxxxxxxx; Foelz.Frank@xxxxxxxxxxxxxxxxxxx
Cc: ORACLE-L
Subject: 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@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 <
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: