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

将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解决了这个问题

看来调整参数会带来意想不到的结果

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-1060526/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26015009/viewspace-1060526/