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
Messages: 10
Registered: November 2008
Junior Member
Dear All,

I am using oracle 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?

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
Messages: 11
Registered: December 2008
Junior Member

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 :

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

Current Time: Sat Oct 22 03:53:06 CDT 2016

Total time taken to generate the page: 0.09523 seconds