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!

100% CPU utilized (found due to (LOCAL=NO) )

KSGAug 16 2012 — edited Aug 17 2012

Hi Friends,

OS: SunOS 5.10

I got an alert like CUP is utilizied 100% and oracle consumed 82%

At 7:00 AM

NPROC USERNAME SWAP RSS MEMORY TIME CPU
190 oracle 25G 24G 38% 234:35:05 82%

When I check at 7:30AM

NPROC USERNAME SWAP RSS MEMORY TIME CPU
161 oracle 22G 22G 35% 230:40:43 13%

How to check what happened at 7:00AM.

OS logs gives some idea?

Suggestions appreciated.

Thanks
KSG

Edited by: KSG on Aug 17, 2012 11:33 AM

This post has been answered by Nikolay Savvinov on Aug 17 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2012

Added on Aug 16 2012

#general-database-discussions

14 comments

749 views