关于异常等待事件kksfbc child completion

原文地址：http://blog.csdn.net/hijk139/article/details/7245325

1,单个进程占用大量CPU资源，并且长时间占用

Name            PID  CPU%  PgSp Owner
oracle      3084608  22.5   4.2 oracle
tnslsnr     2757100   1.5  10.1 oracle
PatrolAg    1642878   0.4  37.3 patrol
oracle      3309798   0.3   4.2 oracle
oracle      4567172   0.3   4.2 oracle
topas       4423822   0.1   6.6 root  
topas       3494028   0.1   6.5 oracle
oracle      3502278   0.0   5.9 oracle
oracle      3174680   0.0   4.6 oracle
topasrec     233946   0.0   1.2 root  
oracle      3641470   0.0   6.0 oracle
oracle      3199192   0.0   5.8 oracle
snmpmagt    1597546   0.0   3.5 patrol
gil           28974   0.0   0.9 root  
HostMoni     262398   0.0   1.0 root  
oracle      1503732   0.0  18.5 oracle
oracle      1892454   0.0   5.9 oracle
oracle      1032610   0.0   5.6 oracle
Script50     250104   0.0   0.8 root  
NetlsnrA     254202   0.0   1.0 root  

2，在执行普通的instert操作
SQL> @process_info.sql
Enter value for pid: 3084608

Session Info
------------------------------------------------------------------------------------------------------------------------------------------------------
 sid, serial#, aud sid : 463 , 46474 , 91847076
 DB User / OS User :  GBA4A / root
 Machine -  Terminal : 4A_GBA2 -
 OS Process Ids : 12088  (Client) 3084608 - 17 (Server)
 Client Program Name : sqlplus@4A_GBA2 (TNS V1-V3)

SQL> @get_sql_by_sqlid.sql
Enter value for sql_id: 6nx116t9znd7g

SQL Text
----------------------------------------------------------------
insert into t_oper_2012_01_13(sid, hostip, seq, eventid, direct,
 "level", logtime, operate, obj , result , duration, vdata ) VAL
UES (352095490, '10.7.6.171', 19058, 0, 1, 5, to_timestamp('2012
-01-13 12:58:05.777086','YYYY-MM-DD hh24:mi:ss.FF6'), '', '', ''
')0, '19

3，该会话在等待kksfbc child completion

SQL> @wait

   SID    SERIAL# OSUSER   USERNAME SVRPROC      PROCESS      EVENT                                             P1         P2         P3
------ ---------- -------- -------- ------------ ------------ ------------------------------ --------------------- ---------- ----------
  1638          3 oracle            3711384      3711384      Streams AQ: qmn coordinator id                     0          0          0
                                                              le wait

  1632          3 oracle            3719484      3719484      Streams AQ: qmn slave idle wai                     0          0          0
                                                              t

  1633          2 oracle            4407360      4407360      Streams AQ: waiting for time m                     0          0          0
                                                              anagement or cleanup tasks

  1365      11580 oracle            3453144      3453144      jobq slave wait                                    0          0          0
   463      46474 root     GBA4A    3084608      12088        kksfbc child completion  

4，metalink上的问题描述如下
This fix has been superseded by bug:8575528.

A session may go into an infinite spin just after a wait
for 'kksfbc child completion'. The spin occurs with 
a stack including kksSearchChildList -> kkshgnc where
kksSearchChildList loops forever.

This problem can also lead to internal error such as any of
ORA-600 [kksSearchChildList1], ORA-600 [kksSearchChildList2]
ORA-600 [kksSearchChildList3], ORA-600 [kkshgnc-nextchild]

Or Trace dumps on kksSearchChildList4 .

Note:
  This fix is disabled by default in 10g.
  To enable this fix you must explicitly set the following
  parameter for instance startup:
    "_cursor_features_enabled" = 10   
   
5,手工kill解决问题 SQL> !kill -9 3084608
如果该问题持续出现，需要打系统补丁并且重启系统修改 "_cursor_features_enabled" = 10