将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解决了这个问题
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-761576/，如需转载，请注明出处，否则将追究法律责任。