ORA-00600 [17182] Raised For A Complex Query (Doc ID 1569000.1)

Last updated on JULY 12, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.