| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle uses 100% CPU
My first suspicion would be some batch process that does not use bind variables. Do a statspack during part of that time (eg 30 minutes) and see if your execute to parse ratio suddenly dives. (also do it for 30 minutes during a time when things are good)
Then slap the developer to write good code.
Jim
-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Foelz.Frank
Sent: Tue 8/16/2005 5:45 AM
To: ORACLE-L
Subject: Oracle uses 100% CPU
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 <
This email and any files attached are confidential and may contain privileged information. If you are not the intended recipient, do not forward or disclose this email, open any attachments, make any copies or save this email anywhere. Please delete this email from your system and notify the sender (maybe via phone + 49-2166-266-0). Thank you very much.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 16 2005 - 08:29:02 CDT
 |
 |