Oracle monopolizes cpu time

[Ferdinand_2]

Lately I have Oracle data bases processes which eat up all cpu time.
When I #top I see the same job eating away at cpu time for more then 3 hours.

I don't have normal users on my systems. Oracle is made available thrue an oracle-user.

We use HP openview for normal monitoring.

Does anyone know a easy/ fast/ simple way to monitor cpu percentage?
I would like to see an alert or email when the cpu has had no idle time for more then 20 minutes.

[Jean-Luc Oudart]

Have you tried glance with specific adviser rules. This may answer you requirement.

man glance.

Jean-Luc

[Ferdinand_2]

I don't have glance installed

Nothing appropriate....

[Jean-Luc Oudart]

You can get an evaluation copy :

follow the links :

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xd1c6d08cc06fd511abcd0090277a778c,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xa9c44e49c5cdd5118ff40090279cd0f9,00.html

Jean-Luc