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