关于异常等待事件kksfbc child completion

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