Ora-00600: [12406] When Optimizer_features_enabled=10.2.0.1 (Doc ID 371982.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2012***
Oracle 10.2.0.1 64-bit
HP-UX Itanium server
Two node RAC database
Using ASM

Symptoms

Alert log shows errors:
ORA-00600: internal error code, arguments: [12406], [], [], [], [], [], [], []


Trace file shows the failing statement:
SELECT ........ FROM .........
WHERE ........in (SELECT ....... FROM ........ START WITH .... IN
(SELECT ........   FROM ........
WHERE ........ = :1) CONNECT BY PRIOR ...... = .........
UNION
SELECT .........
FROM ................,
.....................
WHERE ......... = :2
AND ........... = ................
AND ........ = :3
UNION
SELECT ...........
FROM ....................
WHERE .......... IN(SELECT .......
FROM ...................
CONNECT BY PRIOR ......... = ......
START WITH ..... IN (SELECT ......
FROM ..................
WHERE ........... = :4))
AND .............. = :5 )

Call Stack:

ksedst ksedmp ksfdmp kgeriv kgesiv ksesic0
$cold_qertbFetchByRowID qercbiFilterData qercbiFetch rwsfcd qeruaFetch qersoFetch
qervwFetch qerjotFetch opifch2 opifch opiodr ttcpip
opitsk opiino opiodr opidrv sou2o opimai_real
main main_opd_entry

Changes

This was triggered by setting optimizer_features_enabled to 10.2.0.1

If set to 10.1.0.4, the error does not reproduce.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms