CPU usage is very high on ML580 HP
 

Hi

I have a ML580 HP with 4 Intel(R) Xeon(TM) MP CPU 3.00GHz with HT enabled and 12GB of ram.

OS RedHat AS3 update 8
Oracle Database 10g (9.2.0.1)
Some java programs
Number users connected to the database through Oracle Application server is around 150 to 250

I can see CPU usage is 99% can some one help me to identify what is causing this.

Regards

ps or top
 

If you can, notify your users and stop the oracle service. Then see what's running using top or ps.

Then start having the users log in one by one, and keep monitoring.

If you can get to an x-term while all this is going on, use ps.

I concur - top is certainly the first "weapon of choice".
It may help you to see which processes are chewing up CPU.
Are the db and the app-server are on the same machine?

What's the I/O subsystem - the MOST important part in any
real life database application?



Cheers,
Tink

top is is useful, but I haven't used it since I discovered htop. Now I keep a copy running all the time.

Thanks guys