High CPU system consumption running on Redhat 3.0 update 2 with Oracle 9204

[bobby chen]

We originally have two oracle RAC 9204 with Dell PE6650 and run well. However, we add one new instance to it with DL740(boot disk is smart array 6402). Our plat-form is redhat 3.0 upate 2 with kernel 2.4.21-15ELsmp. The two nodes in Dell PE6650 are still running well. However, the new added instance consumes all CPU system resource after there are about 5 user connections connected. CPU consumed on user is about 10%, but 90% on system. I use spfile when i start up the oracle instances. And i use OCFS to share storage with SAN architeture. Can anybody tell me what should i follow? Thanks in advance.

[Ivan Ferreira]

High system time is related to OS activity, like paging.

Fist you should check that you are not paging, and the memory configuration for oracle is correct. Use the vmstat command to see if you have PI and PO.

You should check metalink, a friend told me that they needed a patch to run RAC on more than two nodes.

Also verify that the node has direct access to the storage, ensure that presentations are correct, check for errors on the sanswitch port statistics.

[Nobody's Hero]

Running oracle:

We had to split the index and DB files on seperate channels for oracle to run properly.

There is also some oracle patches that need to be applied. I can check my box and post them if you havn't installed them.