Problem solve Get help with specific problems with your technologies, process and projects.

Oracle.exe taking 99% of CPU

I have Oracle 8i 8.1.7 on Windows 2000 Advanced Server. The size of the database is 3 GB and the machine has 512 MB of RAM and 40 GB of HDD. 20 users access the database concurrently. Sometimes the Oracle process (oracle.exe) takes 99% of CPU even without any user access. It comes to normal level once I restart the database. Sometimes the 99% persists even after restarting the database. The tablespaces have enough space and each datafile in the tablespace doesn't cross more than 500 MB in size. From my analysis, I couldn't find any resource (hardware) scarcity in that. Could you please suggest me why this CPU utilization shoots up to 99%?

What you really need to look at is how is your database configured and used? What is the size of your SGA? What kinds of SQL statements are being ran and are they properly tuned? You need to shift your focus from the OS/hardware side to what's happening with Oracle. You may need to do some tracing and use explain plan to check out high-cost queries. You may need to increase/decrease the size of the shared pool or database buffer cache.

In the end, CPU utilization in and of itself is not the problem. It's the symptom of a problem located elsewhere. My guess is that you've got some bad SQL out there that needs to be tuned.

For More Information

Dig Deeper on Oracle database design and architecture

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

I have non production standby server , using oracle 12.1 standard edition with asm on window 2012 server.
noone activity is using on this server still physical memory is increasing day by day with 2%. in which 
 1.oracle rdbms kernel execution is getting increase more than 36% with 2% increase day by day ,physical memory is increase continuously more than 46%.
2.oracle rdbms kernel execution with asm is getting 3%.
3.oraagent is getting 1.8%
virtual memory is 8gb

now physical memory is 50% (continuously increase).

how will solve it this problem.