ORA-00600: internal error code, arguments: [kkqcby

Sun May 31 13:06:57 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_1925206.trc:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [], [], []
Sun May 31 13:11:15 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_1429908.trc:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [], [], []
Sun May 31 13:14:41 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_1429908.trc:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [], [], []
Sun May 31 13:18:51 2009
Errors in file /oracle/admin/nrms/udump/nrms_ora_1429908.trc:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [], [], []


主要是建了一个带union的视图
create or replace view v_gis_tedl_km(ID0,BM,MC,DLJC,JZBM,DWBM,DLLX,DLLB,DLXH,XDZS,CQJBM,CQJDKH,SCCJ,SSZT,JCR,CQ,
       WHFS,JGRQ,SM,ZCBM,CJDW,CJR,CJRQ,BZ,JQBM,JQMM,CFFLAG,GCBH,GCMC,YGCBH,YGCMC,
       JX,JRW,DLXJ,ID,FQH,BZ1,BZ2 ) as
select ID0,BM,MC,DLJC,JZBM,DWBM,DLLX,DLLB,DLXH,XDZS,CQJBM,CQJDKH,SCCJ,SSZT,JCR,CQ,
       WHFS,JGRQ,SM,ZCBM,CJDW,CJR,CJRQ,BZ,JQBM,JQMM,CFFLAG,GCBH,GCMC,YGCBH,YGCMC,
       JX,JRW,DLXJ,ID,FQH,BZ1,BZ2
  from tedl@gis
where fqh=1
union
select ID0,BM,MC,DLJC,JZBM,DWBM,DLLX,DLLB,DLXH,XDZS,CQJBM,CQJDKH,SCCJ,SSZT,JCR,CQ,
       WHFS,JGRQ,SM,ZCBM,CJDW,CJR,CJRQ,BZ,BM,JQMM,CFFLAG,GCBH,GCMC,YGCBH,YGCMC,JX,
       JRW,DLXJ,ID,FQH,BZ1,BZ2
  from tedl@gis
where fqh<>1;

然后进行了树查询：
select /*+leading(zqy) use_hash(mdf, jz, zqy)*/
               count(*)
          into iCnt
          from v_gis_temdf mdf,
               v_gis_tejz  jz,
               v_gis_tczqy zqy
         where mdf.JZBM = jz.BM
           and jz.ZQYBM = zqy.BM
           and zqy.AREAID in (select area_id
                                from area
                               start with area_id = in_area_id
                             connect by prior area_id = parent_area);

Oracle就报上述错误



metalink Doc ID:     5126645.8

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

SQL> ALTER SESSION SET "_optimizer_connect_by_cost_based" = FALSE;

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