RE: Oracle uses 100% CPU
- From: "Foelz.Frank" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 16:01:01 +0200
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 <
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
