Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CPU spikes 80% just now at 10:45AM at PROD server

yxes2013Jul 30 2013 — edited Aug 7 2013

Hi all,

11.2.0.1

Aix 6.1

Our Systems Administrator is monitoring every day the CPU/IO/MEMORY usage of our PROD server at OS Level.

He reported today that there is a spike of 80% cpu utilization just now at our PROD database server.

My boss then asked me to investigate what Oracle user/program/process is causing this "spike".

Are there database performance views that I can select to give this info at the specified time?

Thanks a lot,

zxy

This post has been answered by Mr.D. on Jul 31 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2013

Added on Jul 30 2013

#general-database-discussions

46 comments

4,545 views