ORA-00600: [kkqtcorcbk: correlated string no]

Mon May 25 19:07:35 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_844180.trc:
ORA-00600: internal error code, arguments: [kkqtcorcbk: correlated string no], [], [], [], [], [], [], []
Mon May 25 19:07:39 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_1138970.trc:
ORA-00600: internal error code, arguments: [kkqtcorcbk: correlated string no], [], [], [], [], [], [], []
Mon May 25 19:07:43 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_1138970.trc:
ORA-00600: internal error code, arguments: [kkqtcorcbk: correlated string no], [], [], [], [], [], [], []
Mon May 25 19:07:45 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_1138970.trc:
ORA-00600: internal error code, arguments: [kkqtcorcbk: correlated string no], [], [], [], [], [], [], []
Mon May 25 23:36:58 2009


metalink Doc ID:     5126645.8

是由于树状查询造成的，Oracle给出的解决方法为修改隐含参数"_optimizer_connect_by_cost_based"为FALSE。

SQL> ALTER SESSION SET "_optimizer_connect_by_cost_based" = FALSE;

其实解决这个错误最好的方法是改写SQL语句，隐含参数总是会带来一些隐患