Home » RDBMS Server » Server Administration » Oracle Consume 100 % cpu (oracle 10.2.0.4.0 RAC,Linux)
Oracle Consume 100 % cpu [message #395627] Thu, 02 April 2009 01:56 Go to next message
sameer_2230
Messages: 19
Registered: March 2009
Location: India
Junior Member

Top Command result


PID User PR NI VIRT RES SHR S %CPU %MEM TIME+

19202 oracle 20 0 7821m 5.0g 5.0g R 100 32.1 267:52.61
13094 oracle 17 0 7827m 3.2g 3.2g R 100 20.6 487:18.19

Is this suffers?????
Re: Oracle Consume 100 % cpu [message #395629 is a reply to message #395627] Thu, 02 April 2009 01:59 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member

Is this suffers?????
yes. no maybe.

which is acceptable?
Re: Oracle Consume 100 % cpu [message #395648 is a reply to message #395629] Thu, 02 April 2009 02:41 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


You have PID and SID.

Then check what's going on as per your pid and sid.

Babu
Re: Oracle Consume 100 % cpu [message #396198 is a reply to message #395627] Sat, 04 April 2009 19:07 Go to previous messageGo to next message
oraxperts
Messages: 5
Registered: March 2009
Location: Melbourne
Junior Member
if same Oracle process is continuously consuming 100% cpu then Oracle process may be stuck in loop situation, where the Oracle process is waiting for something that is not going to happen.

The other reasons could be related to capacity on the box ie database server was not planned to serve the current workload.

For the first reason, it is better to engage Oracle support because support analyst can compare the systemstate dumps at different time and identify whether it is a looping problem or not.

Cheers

[Updated on: Sun, 05 April 2009 00:13] by Moderator

Report message to a moderator

Re: Oracle Consume 100 % cpu [message #396200 is a reply to message #395627] Sat, 04 April 2009 19:31 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>if same Oracle process is continuously consuming 100% cpu then Oracle process may be stuck in loop situation,
>where the Oracle process is waiting for something that is not going to happen.
An Oracle process in WAIT state does NOT consume CPU cycles.

Provide reproducible test case to prove your claim.

Please stop spamming this forum with your self serving URL

[Updated on: Sat, 04 April 2009 19:32]

Report message to a moderator

Re: Oracle Consume 100 % cpu [message #396424 is a reply to message #395627] Mon, 06 April 2009 10:07 Go to previous message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member
BS - I expect to get shot down in flames for this...

But - doesnt Oracle spin at a high rate when retrying latch resources?

I am getting more and more involved in application work these days... but I'm sure I still remember a thing or two about Oracle internals Wink

PS - Approve of the Spam tho - some other forums are overrun with it.
Previous Topic: How to protect object from ddl and dml commands
Next Topic: root.sh and orainst.sh
Goto Forum:
  


Current Time: Thu Dec 08 20:21:19 CST 2016

Total time taken to generate the page: 0.05689 seconds