ORA-00600 에러 처리방법

alter system set "_optimizer_connect_by_cost_based" = false scope=both;

ORA-00600: 내부 오류 코드, 인수 : [qkacon:FJfsrwo], [5], [], [], [], [], [], []..

bug number : Bug 5254539

A SQL statement involving a hierarchical query (CONNECT BY)
using cursor statements in the select list may fail with
ORA-600 [qkacon:FJfsrwo]

===================================================================================================

alter system set "_optimizer_cost_based_transformation" = off scope=both;

===================================================================================================
The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.3 - 10.2
This problem can occur on any platform.

Errors ORA 600 internal error code, arguments: [qctcte1],[0],[%s], [%s], [%s],

Symptoms
ORA-00600 [qctcte1] is encountered while performing a nested select which might include functions like distinct or have an order by clause.

Example:

Sql> CREATE OR REPLACE TYPE int_list IS VARRAY(200) OF INTEGER;

Sql> CREATE TABLE test (id INTEGER);

Sql> SELECT id FROM ( SELECT rp.id FROM (SELECT DISTINCT column_value ID FROM
TABLE(int_list(1,1,2))) rp, test p WHERE p.id = 1 ORDER BY p.id DESC)

ERROR at line 2:
ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []

 

Cause
An inconsistent datatype is reported during typechecking when parsing a query. This is bug 3557906.
Fix
There are several Workarounds :

1> Remove the desc from the order by clause

Sql > SELECT id FROM ( SELECT rp.id FROM (SELECT DISTINCT column_value ID
FROM TABLE(int_list(1,1,2))) rp, test p WHERE p.id = 1 ORDER BY p.id )

2> Alter session set "_complex_view_merging"=false;

3> Remove the distinct clause

Sql > SELECT id FROM ( SELECT rp.id FROM (SELECT column_value ID FROM TABLE(int_list
(1,1,2))) rp, test p WHERE p.id = 1 ORDER BY p.id DESC)

4> Remove the order by clause

Sql > SELECT id FROM ( SELECT rp.id FROM
(SELECT column_value ID FROM TABLE(int_list(1,1,2))) rp, test p WHERE p.id = 1 )

5> _pred_move_around = false

This is fixed in 10.2 and will be fixed in the 9206 patchset.
References
<Bug:3557906> ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [QCTCTE1], [0],

쿼리문에 흰트를 사용해도 되네요..
 /*+ NO_CONNECT_BY_COST_BASED */ 

  or

/*+ OPT_PARAM('_optimizer_connect_by_cost_based', 'false') */