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_at_labor.state.ny.us] Sent: Tuesday, August 16, 2005 3:54 PM
To: vitalisman_at_gmail.com; Foelz.Frank_at_scheidt-bachmann.de 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_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