topic Re: High CPU system consumption running on Redhat 3.0 update 2 with Oracle 9204 in Operating System - Linux

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

bobby chen — Mon, 01 Aug 2005 11:15:31 GMT

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.

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

Ivan Ferreira — Mon, 01 Aug 2005 14:37:52 GMT

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.

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

Nobody's Hero — Tue, 02 Aug 2005 08:33:26 GMT

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.