RE: Oracle uses 100% CPU
- From: "Foelz.Frank" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 16:37:52 +0200
Due to our changelogs we were able to find what's wrong. We figured out,
that one of our processes is causing the database to keep working in the
wilderness.
Following Jim Kennedy's advice, we slapped the developer ;-)
Thanks to all who answered.
> 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 <
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
