Home » RDBMS Server » Performance Tuning » Database Hung due to CPU utilization (Oracle 10.2.0.2.0,Solaris10)
Database Hung due to CPU utilization [message #409203] Sat, 20 June 2009 06:56 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



Hi all,

I have a question which i would like to ask you.
Say for example ,my database got hanged.The reason was ,a session has 100% CPU utilization .What could be the solution for this?

Should i kill the session or something else?

Thanks in advance
Re: Database Hung due to CPU utilization [message #409210 is a reply to message #409203] Sat, 20 June 2009 09:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe, maybe not, can you?

Regards
Michel
Re: Database Hung due to CPU utilization [message #409221 is a reply to message #409210] Sat, 20 June 2009 13:09 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Try to reduce CPU process ( I mean; check any other process taking memory).

Thanks

[Updated on: Sat, 20 June 2009 23:53]

Report message to a moderator

Re: Database Hung due to CPU utilization [message #409246 is a reply to message #409203] Sun, 21 June 2009 02:13 Go to previous messageGo to next message
amitzil
Messages: 9
Registered: June 2009
Junior Member
Hi,
It's not that easy to reduce the CPU, since there are many reasons for high CPU usage (it can be very utilized SQL, latch problem, Oracle bug, etc.)

First, try to find the problematic session and what it does (assuming you're running linux and have the process id):

select sid,
       username,
       program,
       machine,
       sql_id,
       event,
       p1,
       p2
from v$session
where paddr = (select addr from v$process where spid=<process_id>);


Execute this several times with the id of the process that consumes the CPU, paste the output (especially the event)
You can also find the SQL text from v$sql using the sql_id from the query.

This will help us to analyze the problem.

Liron Amitzi
Senior DBA consultant

[Updated on: Sun, 21 June 2009 02:36] by Moderator

Report message to a moderator

Re: Database Hung due to CPU utilization [message #409269 is a reply to message #409246] Sun, 21 June 2009 08:04 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks for your response.I have not faced such problem yet.Just wanted to know what could be the solution for such problem.

Will paste the output of it when i face it in future.

Regards,
Balaji
Previous Topic: May you explain to me about AWR?
Next Topic: performance problem with query
Goto Forum:
  


Current Time: Fri Dec 02 18:58:01 CST 2016

Total time taken to generate the page: 0.22425 seconds