\u5ba2\u6237\u768411.2 RAC\u73af\u5883\u4e2d\u7a81\u7136\u4e00\u4e2aO002\u8fdb\u7a0b\u5360\u7528\u4e86100%\u7684CPU\uff0c\u4e14\u4e00\u76f4\u4e0d\u91ca\u653e\u3002
\n\u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u7684\u539f\u56e0\u5e94\u8be5\u662f\u901a\u8fc7ASMCMD\u5de5\u5177\u4eceASM\u4e2d\u62f7\u8d1d\u4e86\u4e00\u4e2a\u5f52\u6863\u65e5\u5fd7\u5230\u672c\u5730\u78c1\u76d8\uff0c\u968f\u540e\u5c31\u53d1\u73b0\u4e00\u4e2aora_<\/p>\n
[root@node-2 ~]# top\r\ntop - 21:14:25 up 257 days, 4:33, 2 users, load average: 1.69, 1.70, 1.56\r\nTasks: 994 total, 2 running, 991 sleeping, 0 stopped, 1 zombie\r\nCpu(s): 2.2%us, 0.1%sy, 0.0%ni, 97.5%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st\r\nMem: 132060636k total, 131006336k used, 1054300k free, 535524k buffers\r\nSwap: 67108856k total, 1649936k used, 65458920k free, 39758892k cached\r\n PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND \r\n 7622 oracle 25 0 50.6g 18m 16m R 100.0 0.0 9498:03 oracle \r\n29924 root RT 0 304m 86m 54m S 2.0 0.1 5333:37 osysmond.bin\r\n13804 root 15 0 13424 1844 828 R 1.6 0.0 0:00.16 top\r\n29158 oracle 15 0 50.6g 10g 10g S 1.0 8.2 317:51.59 oracle\r\n30337 root 15 0 971m 25m 13m S 1.0 0.0 1938:12 orarootagent.bi\r\n.\r\n.\r\n.\r\n 25 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog\/7\r\n[root@node-2 ~]# ps -ef|grep 7622\r\noracle 7622 1 2 2011 ? 6-14:18:09 ora_o002_orcl2\r\nroot 13810 13645 0 21:14 pts\/1 00:00:00 grep 7622<\/pre>\n\u4ece\u6570\u636e\u5e93\u4e2d\u67e5\u8be2\uff0c\u53d1\u73b0\u8fd9\u4e2a\u4f1a\u8bdd\u5904\u4e8e\u7a7a\u95f2\u7b49\u5f85\u72b6\u6001\uff1a<\/p>\n
[oracle@settle-2 ~]$ sqlplus \/ as sysdba\r\nSQL*Plus: Release 11.2.0.2.0 Production on Mon Apr 23 21:14:45 2012\r\nCopyright (c) 1982, 2010, Oracle. All rights reserved.\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\nSQL> set pages 100 lines 140\r\nSQL> select sid, username, program, status, event from v$session where paddr in (select addr from v$process where spid = 7622);\r\n SID USERNAME PROGRAM STATUS EVENT\r\n---------- ---------- ------------------------------ -------- ------------------------------\r\n 529 oracle@node-2 (O002) ACTIVE class slave wait\r\nSQL> select sql_id, prev_sql_id from v$session where sid = 529;\r\nSQL_ID PREV_SQL_ID\r\n------------- -------------\r\n<\/pre>\n\u53ef\u4ee5\u770b\u5230\uff0c\u8fd9\u4e2a\u4f1a\u8bdd\u4e00\u76f4\u5904\u4ee5\u7a7a\u95f2\u7b49\u5f85\uff0c\u800c\u4e14\u6ca1\u6709\u6267\u884c\u4efb\u4f55SQL\u8bed\u53e5\u3002<\/p>\n
SQL> select sid, serial# from v$session where sid = 529;\r\n SID SERIAL#\r\n---------- ----------\r\n 529 43\r\nSQL> exec dbms_monitor.session_trace_enable(529, 43, true, true)\r\nPL\/SQL procedure successfully completed.\r\nSQL> exec dbms_monitor.session_trace_disable(529, 43)\r\nPL\/SQL procedure successfully completed.<\/pre>\n\u901a\u8fc7\u8bbe\u7f6eTRACE\uff0c\u53d1\u73b0\u8fd9\u4e2a\u5f02\u5e38\u7684\u4f1a\u8bdd\u5e76\u6ca1\u6709\u4ea7\u751f\u4efb\u4f55\u7684TRACE\u6587\u4ef6\u3002
\n\u7531\u4e8eONNN\u8fdb\u7a0b\u662fASM\u8fde\u63a5\u6c60\u8fdb\u7a0b\uff0c\u5f53\u6570\u636e\u5e93\u5728ASM\u4e0a\u521b\u5efa\u6587\u4ef6\u65f6\uff0c\u5c31\u4f1a\u901a\u8fc7ONNN\u8fdb\u7a0b\u6765\u5b8c\u6210\uff0c\u8fd9\u4e2a\u8fdb\u7a0b\u5728\u65e5\u5e38\u5f88\u5c11\u4f1a\u5904\u4e8e\u5de5\u4f5c\u72b6\u6001\u3002<\/p>\n
[oracle@node-2 ~]$ ps -ef|grep ora_o\r\noracle 3831 1 0 Feb15 ? 00:00:03 ora_o004_orcl2\r\noracle 6350 1 0 2011 ? 00:00:08 ora_o000_orcl2\r\noracle 6358 1 0 2011 ? 00:00:08 ora_o003_orcl2\r\noracle 7475 1 0 2011 ? 00:00:00 ora_o001_orcl2\r\noracle 7622 1 2 2011 ? 6-15:38:56 ora_o002_orcl2\r\noracle 28211 28168 0 22:35 pts\/1 00:00:00 grep ora_o\r\n[oracle@node-2 ~]$ kill -9 7622<\/pre>\n\u7531\u4e8eONNN\u8fdb\u7a0b\u5e76\u975e\u7cfb\u7edf\u6838\u5fc3\u8fdb\u7a0b\uff0c\u4e14Oracle\u4f1a\u5728\u9700\u8981\u7684\u65f6\u5019\u81ea\u52a8\u5206\u914dONNN\u8fdb\u7a0b\uff0c\u56e0\u6b64\u53ef\u4ee5\u901a\u8fc7kill -9\u7684\u65b9\u6cd5\u6765\u6e05\u9664\u4f1a\u8bdd\u3002\u7ed3\u675f\u8fdb\u7a0b\u540e\uff0ctop\u547d\u4ee4\u663e\u793a\u5360\u7528100%CPU\u8d44\u6e90\u7684\u8fdb\u7a0b\u5df2\u7ecf\u6d88\u5931\u3002
\n\u6839\u636eMOS\u7684\u6700\u65b0\u66f4\u65b0\uff0c\u8fd9\u4e2a\u95ee\u9898\u5c5e\u4e8eBUG:12929268\u5bf9\u5e94\u7684\u6587\u6863\u4e3aora_o00n Process High CPU Usage in 11.2.0.2 [ID 1459376.1]\u3002
\n\u6839\u636e\u6587\u6863\u7684\u63cf\u8ff0\uff0c\u5982\u679cONNN\u8fdb\u7a0b\u7a7a\u95f2\u65f6\u95f4\u8d85\u8fc7248.5\u5929\u5de6\u53f3\uff0c\u4e5f\u5c31\u662f\u6309\u7167\u767e\u5206\u4e4b\u4e00\u79d2\u8ba1\u7b97\u8d85\u8fc72G\uff0c\u5c31\u4f1a\u5bfc\u81f4ONNN\u8fdb\u7a0b\u9677\u5165\u6b7b\u5faa\u73af\u4e2d\u3002Oracle\u5bf9\u4e8e\u8fdb\u7a0b\u7684\u6700\u5927\u7b49\u5f85\u65f6\u95f4\u7684\u5b9a\u4e49\u5e76\u4e0d\u662f\u65e0\u7b26\u53f7\u7684LONG\uff0c\u5bfc\u81f4\u8fdb\u7a0b\u7b49\u5f85\u65f6\u95f4\u53ea\u67092G\u5398\u79d2\uff0c\u800c\u4e0d\u662f4G\u3002
\nOracle\u76ee\u524d\u6ca1\u6709\u660e\u786e\u7684fixed\u8ba1\u5212\uff0c\u800c\u7ed9\u51fa\u7684\u89e3\u51b3\u65b9\u6848\u548c\u6211\u4e0a\u9762\u7684\u65b9\u6cd5\u4e00\u81f4\uff0c\u5c31\u662fKILL\u6389\u5bf9\u5e94\u7684\u8fdb\u7a0b\u3002\u53e6\u5916\u91cd\u542f\u7cfb\u7edf\u53ef\u4ee5\u4fdd\u8bc1250\u5929\u5185\u4e0d\u4f1a\u518d\u6b21\u51fa\u73b0\u540c\u6837\u7684\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u768411.2 RAC\u73af\u5883\u4e2d\u7a81\u7136\u4e00\u4e2aO002\u8fdb\u7a0b\u5360\u7528\u4e86100%\u7684CPU\uff0c\u4e14\u4e00\u76f4\u4e0d\u91ca\u653e\u3002 \u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u7684\u539f\u56e0\u5e94\u8be5\u662f\u901a\u8fc7ASMCMD\u5de5\u5177\u4eceASM\u4e2d\u62f7\u8d1d\u4e86\u4e00\u4e2a\u5f52\u6863\u65e5\u5fd7\u5230\u672c\u5730\u78c1\u76d8\uff0c\u968f\u540e\u5c31\u53d1\u73b0\u4e00\u4e2aora_ [root@node-2 ~]# top top – 21:14:25 up 257 days, 4:33, 2 users, load average: 1.69, 1.70, 1.56 Tasks: 994 total, 2 running, 991 sleeping, 0 stopped, 1 zombie Cpu(s): 2.2%us, 0.1%sy, 0.0%ni, 97.5%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st … Continue reading