关于oracle dbresp.pl进行耗尽CPU的解决办法

今天早上登陆服务器时反应很慢，进去后投票一看，我擦CPU全站满了如下图：

oracle    1158  1.5  0.1  23004  7780 ?        R    Oct30  22:11 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1212  2.7  0.1  23004  7780 ?        R    Oct27 148:01 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1282  3.1  0.1  23008  7784 ?        R    Oct27 192:43 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1367  2.3  0.1  23004  4092 ?        R    Oct28 110:51 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1379  1.6  0.1  23008  7780 ?        R    00:12   9:37 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1444  2.1  0.1  23008  4092 ?        R    Oct28  82:42 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1465  4.1  0.1  23008  4092 ?        R    Oct26 286:46 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1608  1.8  0.1  23004  7780 ?        R    Oct29  40:22 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1663  1.9  0.1  23004  7780 ?        R    Oct29  59:45 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1789  2.5  0.1  23012  7784 ?        R    Oct27 140:23 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1941  1.6  0.1  23008  7780 ?        R    00:27   9:22 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    1960  2.3  0.1  23004  4092 ?        R    Oct28 107:43 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl
oracle    2030  2.1  0.1  23008  7780 ?        R    Oct28  81:42 /home/database/oracle/product/10.2.0/db_1/perl/bin/perl /home/database/oracle/product/10.2.0/db_1/sysman/admin/scripts/db/dbresp.pl

wc了一下居然有520个进程，我擦 ，而且应用还停着，关闭数据库这些pl进程仍然存在，最后直接批量kill掉，恢复正常

ps -aux|grep product/10.2.0/db_1/perl/bin/perl|grep -v grep|cut -c 9-15|xargs kill -9 

分析问题：

原因：

根据metalink  Doc ID:  764140.1描述：The Response metric is making a timed out then the Agent starts other process to take the Response metric. The process to kill the PID taking the Response metric is failing increasing the process running dbresp.pl。

解决方法：

同样根据根据metalink  Doc ID:  764140.1：

To implement the solution, please execute the following steps:
1. Stop DBConsole
emctl stop dbconsole

2. Kill any running process.
ps -ef | grep /opt/app/oracle/<hostname>_<sid>
Kill any returned process.

ps -ef |grep '问题进程' |cut -c 10-15 |xargs kill -9

3. Follow fix
Note.361612.1 Ext/Mod Problem Performance Agent High CPU Consumption Gen

4. Start DB Console
emctl start dbconsole