ORA-600(qctopn1)錯誤

客戶11.2.0.2環境資料庫出現這個ORA-600錯誤。

詳細錯誤資訊如下：

Tue Jun 12 09:50:47 2012
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_28252.trc (incident=329000):
ORA-00600: internal error code, arguments: [qctopn1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_329000/orcl2_ora_28252_i329000.trc
Tue Jun 12 09:51:21 2012
Dumping diagnostic data in directory=[cdmp_20120612095121], requested by (instance=2, sid=28252), summary=[incident=329000].
Tue Jun 12 09:51:21 2012
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Jun 12 09:51:22 2012
Sweep [inc][329000]: completed
Sweep [inc2][329000]: completed

導致這個錯誤的原因在於CREATE TABLE語句執行的時候嘗試對子查詢接巢狀。詳細的描述可以參考Bug 10398457 - ORA-600 [qctopn1] from disjunctive Subquery Unnest on a CREATE TABLE as SELECT [ID 10398457.8]。這個錯誤確認影響的資料庫版本為11.2.0.2，Oracle在11.2.0.3中FIXED了這個問題。

除了版本升級外，還可以透過設定隱含引數"_optimizer_cost_based_transformation"為FALSE，或者設定"_fix_control"的值為"4768040:OFF"來避免子查詢的UNNEST。