客户的数据库是Oracle 11.1.0.6 RAC for AIX，在其中一个节点，执行topas命令，olsnodes进程的CPU消耗一直排在最前面，查看METALINK，发现这是Oracle数据库在该版本的一个bug，相关信息如下：

Olsnodes Produces CPU Spikes With Many Logs in $CRS_HOME/log//client Directory [ID 729349.1]
修改时间:2009-5-13

类型:PROBLEM

状态:MODERATED

优先级:2

In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6
This problem can occur on any platform.

Symptoms

Olsnodes produces CPU spikes with many css*.log files in CRS_HOME/log//client directory
These css*.log files have a message saying: "olsnodes successful".

Cause

The issue has been identified and fixed with unpublished Bug 6004127.
When executing olsnodes successfully, it scans $CRS_HOME/log//client directory and generates a new cssxxx.log file.

Solution

Remove the log files under $ORA_CRS_HOME/log//client/css*.log in regular intervals with a cronjob.

Unpublished Bug 6004127 has been fixed in 11.1.0.7 and 10.2.0.4 CRS bundle Patch #2 onwards. Bundle Patch information is available in Note 756671.1

References

BUG:6837349 - OLSNODES OUTPUTS CLUSTER INFORMATION BUT THEN SPINS
NOTE:756671.1 - Oracle Recommended Patches -- Oracle Database

参考文章：
https://forums.oracle.com/forums/thread.jspa?messageID=3585721
http://surachartopun.com/2009/06/olsnodes-make-cpu-spikes.html

--end--

ITPub博客

Olsnodes Produces CPU Spikes With Many Logs [ID 729349.1]

Applies to:

Symptoms

Cause

Solution

References

最新文章