MAX OUT CPU (100%)

[dbadmin]

I have a quick issue and I need some advise on this.

I have an Oracle server running windows 2000 server with 933 MHZ and 1.2 G of memory. I have 6 8 databases running on this box and the total memory allocated to these databases are about 800M.

everytime when someone do and insert or update to anyone of these databases, I look at the CPU and it's max out 100% and every body else experience the performance issues on the whole box. I looked at the CPU and see that this process use almost all of its CPU so that it's slow the whole box.

I looked at the swap file and It's not bad at all. So what could be the problem ??? need more memory on the Box ??? add another CPU ????

How to approach this problem, please advise.

Thanks

 

[tgilmore]

You should develope a baseline with Performance Monitor. This will help you to see the big picture over a period of time. Also, FYI: If your Processor is pegged out at 100% and the threads are at 2% that usually means that you need a new CPU. Hope this helps!

 

[dbadmin]

Thanks for your reply,

I am sorry I am new with this issue. could you please give me some more hint about the baseline with performance monitor ??? and how to find out the percent of the thread????

Thanks

 

[dbadmin]

Anyone has suggestions or advises ???