ORA-00600 [KKFDGDALO1] on SQL executed in PARALLEL with hint /*+ INDEX_FFS */ (Doc ID 2736215.1)

Last updated on JANUARY 19, 2022

Applies to:

Symptoms

SQL> alter session enable parallel query;

Session altered.

SQL> select /*+ index_ffs(t) */ t.utrnno from <TABLE NAME 1> t,

<TABLE NAME 2> dt where dt.opt_cleanup_batches__oid = 366

and dt.utrnno = t.utrnno order by t.utrnno;

select /*+ index_ffs(t) */ t.utrnno from SVISTA.TMP_EPAY_ALG_TRANS t,

svista.TMP_CLNP_KEYS$CURR_TRANS dt where dt.opt_cleanup_batches__oid = 366

and dt.utrnno = t.utrnno order by t.utrnno

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kkfdGdAlo1], [1], [0], [], [], [], [], [], [], [], [], []

STACK TRACE:

Error: ORA-600 [kkfdGdAlo1] [1] [0] [] [] [] [] [] [] [] [] []

[00]: dbgexPopulateIncCtx [diag_dde]

[01]: dbgexProcessError [diag_dde]

[02]: dbgeExecuteForError [diag_dde]

[03]: dbgePostErrorKGE [diag_dde]

[04]: dbkePostKGE_kgsf [rdbms_dde]

[05]: kgeadse []

[06]: kgerinv_internal []

[07]: kgerinv []

[08]: kgeasnmierr []

[09]: kkfdGdAlo [SQL_Code_Generator]<-- Signaling

[10]: kkfdjoi [SQL_Code_Generator]

[11]: qkajoi [SQL_Code_Generator]

[12]: qkaqkn [SQL_Code_Generator]

[13]: qkadrv [SQL_Code_Generator]

[14]: opitca [OPI]

[15]: kksFullTypeCheck [cursor]

[16]: rpiswu2 [RPI]

[17]: kksSetBindType [cursor]

[18]: kksfbc [cursor]

[19]: opiexe [Time_Limit]

[20]: kpoal8 [PROGINT_MISC]

[21]: opiodr [OPI]

[22]: ttcpip []

[23]: opitsk [OPI]

[24]: opiino [OPI]

[25]: opiodr [OPI]

[26]: opidrv [OPI]

[27]: sou2o []

[28]: opimai_real [OPI]

[29]: ssthrdmain []

[30]: main []

[31]: __start []

Cause

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