ORA-00600 [kksfbc-reparse-infinite-loop] & ORA-00600 [15212] when running query (Doc ID 788939.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Jun-2013***

Symptoms

A query fails while these errors were reported:

Both errors are related because the affect the same query and apparently the same child. 


1. ORA-00600 [kksfbc-reparse-infinite-loop]

ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0xFFFFFFFF7C752CC0], [], [], [], [], [], []
Current SQL statement for this session:
SELECT LOG_SV_ID,LOG_TYPE,REQUESTING_SPID,TN,DESTINATION_SPID,LOG_SV_ALL_VIEW.
SV_ID,STATUS,LNP_TYPE,SV_STATUS,SV_STATUS_OLD,LOG_SV_TYPE,EVENT_ID,SYSTEM_ID,
USER_ID,STATUS_CHANGE_CAUSE_CODE,LOG_SV_ALL_VIEW.CREATION_TS,OLD_SPID,
EDR_DISCONNECT, CLIENT_COMPLETION_DT from LOG_SV_ALL_VIEW where SV_ID = :
"SYS_B_0"

Call Stack Trace
~~~~~~~~~~~~~~~~
kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr ttcpip

2. ORA-00600: [15212]

*** 2009-03-02 15:44:46.815
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15212], [0xFFFFFFFF7C7600A8], [0],
[0x45BBF3728], [0x459148D40], [0x000000000], [], []
Current SQL statement for this session:
SELECT LOG_SV_ID,LOG_TYPE,REQUESTING_SPID,TN,DESTINATION_SPID,LOG_SV_ALL_VIEW.
SV_ID,STATUS,LNP_TYPE,SV_STATUS,SV_STATUS_OLD,LOG_SV_TYPE,EVENT_ID,SYSTEM_ID,
USER_ID,STATUS_CHANGE_CAUSE_CODE,LOG_SV_ALL_VIEW.CREATION_TS,OLD_SPID,
EDR_DISCONNECT, CLIENT_COMPLETION_DT from LOG_SV_ALL_VIEW where SV_ID = :
"SYS_B_0"


Call Stack Trace
~~~~~~~~~~~~~~~~
kksfbc opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv
...

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