Home » RDBMS Server » Performance Tuning » Oracle.exe using above 95% cpu usage (Oracle, 10g, Windows XP)
Oracle.exe using above 95% cpu usage [message #384524] Wed, 04 February 2009 03:46 Go to next message
skmmmf
Messages: 10
Registered: November 2008
Junior Member
Dear All,

I am using oracle 10.0.1.2.0 version for our production DB. We have 5GB RAM in the DB server & assigned 1.5 GB for SGA. In my DB server, oracle.exe process is always using full cpu usage.

We restarted the Service, but still its using 95-99% cpu usage.

What could be the problem? Can anyone suggest the solution for this?

Regards,
Mohideen.
Re: Oracle.exe using above 95% cpu usage [message #384551 is a reply to message #384524] Wed, 04 February 2009 04:55 Go to previous message
TomG
Messages: 11
Registered: December 2008
Junior Member
Hello,

You need first to identify if the culprit is a background or user process. To get the threads of Oracle.exe you can use something like Qslice tool.
Have a look at this :
http://it.toolbox.com/blogs/david/how-to-identify-cpu-hogging-oracle-sessions-on-a-windows-server-21789

Tom
Previous Topic: SQL performance Tuning help
Next Topic: Choosing execution plan with optimizer_index_caching
Goto Forum:
  


Current Time: Thu Dec 08 12:07:27 CST 2016

Total time taken to generate the page: 0.23567 seconds