修改参数引发的ORA-00600: internal error code, arguments: [qctcte1],..

将cursor_sharing从EXACT修改为similar为了降低硬解析但是执行下面的语句时报

ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], []

select t.*, level as org_level from (select a.aab034 as center_id, a.aab034 as org_code, b.aaa013 as org_name,
to_number(a.aaz198) as org_id, :"SYS_B_0" as org_up_id, :"SYS_B_1" as org_type from af01 a, aa13 b
where a.aab034 = b.aaa027 union all select a.aaa027 as center_id, a.baf013 as org_code, b.aab069 as org_
name, to_number(a.aaf013) as org_id, to_number(c.aaz198) as org_up_id, :"SYS_B_2" as org_type fro
m af08 a, ae10 b, af01 c where a.aaf013 = b.aaz001 and a.aaa027 = c.aab034 union all select a.aaa027 as center_id,
c.aaf030 as org_code, b.aab069 as org_name, to_number(c.aaz070) as org_id, to_number(a.aaf013
) as org_up_id, :"SYS_B_3" as org_type from af08 a, ae10 b, af02 c where c.aaz070 = b.aaz001 and c.aaf013 =
a.aaf013) t start with org_up_id = :"SYS_B_4" connect by prior org_id = org_up_id order siblings by org_code

后将cursor_sharing从similar修改为exact解决了这个问题
看来调整参数会带来意想不到的结果
修改cursor_sharing参数引发的ORA-00600: internal error code, arguments: [qctcte1], [0], []..

One thought on “修改参数引发的ORA-00600: internal error code, arguments: [qctcte1],..

发表评论

电子邮件地址不会被公开。