Database Administration (MOSC)

MOSC Banner

CPU is too busy!

edited Jul 26, 2010 10:15PM in Database Administration (MOSC) 11 commentsAnswered
 dear all:

             my oracle(10.2.0.3) is installed on unix platform.it's a rac with two node.this week it run properly.

At 10:43 am the cpu of node 2 was used totally by oracle.and the database is not down,but i can't do anything in database such as select * from dba_users....... the same thing accured two weeks ago at almost time. the awr is below:

 Buffer Nowait %:99.36Redo NoWait %:100.00
Buffer Hit %:94.94In-memory Sort %:100.00
Library Hit %:99.94Soft Parse %:99.91
Execute to Parse %:31.66Latch Hit %:99.56
Parse CPU to Parse Elapsd %:4.92% Non-Parse CPU:99.96

CPU time 4,924 40.6 
db file sequential read1,809,9092,834223.4User I/O
gc cr multi block request

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center