ORA-00600 [17182] Raised For A Complex Query
(Doc ID 1569000.1)
Last updated on JULY 12, 2020
Applies to:
Oracle Text - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.
Symptoms
When executing a complex query using PL/SQL functions and Oracle Text functionality
the query crashes with:
ORA-00600: internal error code, arguments: [17182], [0x9FFFFFFFFB57D018], [], [], [], [], [], [], [], [], [], []
Call Stack Trace:
$cold_kghfrf kcikghfrf drumcmf dredpdst dredSkiplistHeaderFirst dredParseHeader dredilpg dredifpg dredmseek dredseek
drebytc drywnfc dryoftc drexqiftc drexqpftc drexqxs drexrcontains qxopqxex qeroifcsu qxopqdex qxopqeuo evaopn2
evareo expepr expeal qertbFetchByRowID qergiFetch qerjotFetch qerjoFetch qerflFetch qerflFetch $cold_qertqoFetch
$cold_qerpxFetch qerflFetchOutside qercoFetch rwsfcd qeruaFetch qersoProcessULS qersoFetch qervwFetch qerjotFetch
qerjotFetch rwsfcd qerhjFetch qerghFetch qersoProcessULS qersoFetch qervwFetch qercoFetch opifch2 opifch opipls
opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run
peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main main_opd_entry
Other sessions also crash with:
ORA-00600: internal error code, arguments: [17183], [0x9FFFFFFFFBE96F98], [], [], [], [], [], [], [], [], [], []
ORA-20000: Oracle Text error:
DRG-50850: ORA-00600: internal error code, arguments: [17182], [0x9FFFFFFFFBEA3CF8], [], [], [], [], [], [], [],
The problem seems to be caused by the complexity of the query. Removing tables from the join conditions or simplifying the query in other ways
allows the query to complete.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |