Originally Posted by asankacgl
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 (184.108.40.206)
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.
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?