修改cursor_sharing引數引發的ORA-00600: internal error code, arguments: [qctcte1], [0], []..

eric0435發表於2013-05-20
Error
將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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章