CPU is too busy!
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.36 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 94.94 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.94 | Soft Parse %: | 99.91 |
Execute to Parse %: | 31.66 | Latch Hit %: | 99.56 |
Parse CPU to Parse Elapsd %: | 4.92 | % Non-Parse CPU: | 99.96 |
CPU time | 4,924 | 40.6 | |||
db file sequential read | 1,809,909 | 2,834 | 2 | 23.4 | User I/O |
gc cr multi block request |