一个跑在aix操作系统上的Oracle 10.2.0.3的数据库,经常出现'kksfbc child completion' 的等待事件,并且这些等待事件一旦出现,这些等待事件和相关的session永远不会消失。查了下,说是个bug,需要修改此隐含参数,具体过程如下:
"_cursor_features_enabled" = 10 过程如下: SQL> alter system set "_cursor_features_enabled" = 10 scope=spfile;
SQL> shutdown immediate;
SQL> startup; 有谁知道oracle 隐含参数_cursor_features_enabled的具体含义?谢谢!!!
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]
Note:
Fixes for this bug in 10g and 11gR1 are disabled by default.
To enable this fix you must explicitly set the following parameter for instance startup:
"_cursor_features_enabled" = 10