Query on Partitioned Table Results in ORA-00600 [kkpapDIGetNum2] (Doc ID 1573905.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Query on partitioned table errors out with:

ORA-00600: internal error code, arguments: [kkpapDIGetNum2], [360], [360], [91], []

The following are the top functions in the in the incident trace:

----- Incident Context Dump ----- Address: 0xffffffff7fff3a88 Incident ID: 258654 
Problem Key: ORA 600 [kkpapDIGetNum2] 
Error: ORA-600 [kkpapDIGetNum2] [360] [360] [91] [] [] [] [] [] [] [] [] [00]: dbgexProcessError [diag_dde] [01]: 
 dbgePostErrorKGE [diag_dde] [02]: dbkePostKGE_kgsf [rdbms_dde] [03]: kgerinv_internal [] [04]: kgerinv [] [05]: 
 kgeasnmierr [] [06] kkpapDIGetNum [PART]<-- Signaling [07]: qkaPobs [SQL_Code_Generator] [08]: 
 qkadrv [SQL_Code_Generator] [09]: qkadrv [SQL_Code_Generator] [10]: qkadrv [SQL_Code_Generator] [11]: 
 opitca [] 

The error occurs during parsing, as the state of the corresponding cursor in the incident trace shows below.

Consequently the error can be reproduced with EXPLAIN PLAN FOR SELECT ..., without executing the query.

Cursor#3(0xffffffff7a441ca0) state=SYNTAX curiob=0xffffffff7a45b990
curflg=4c fl2=0 par=0x0 ses=0x2171b63430
----- Dump Cursor sql_id=c5801f68vc5kh xsc=0xffffffff7a45b990 cur=0xffffffff7a441ca0 -----

LibraryHandle:  Address=1f5cdc7e20 Hash=91b61650 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
 ObjectName:  Name=select * from ccb.ONLINE_FATURA_DETAY where rat_gsm_no='5442156126' and   RAT_LAST_DIGIT = '6' and
INVOICE_PERIOD = '201303'

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