ORA-600 [kkqsfcsi-1] with query rewrite (Doc ID 2065557.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

You may see the below error message in the alert log file:

Faling query may resemble:

----- Current SQL Statement for this session (sql_id=a664chg7jzyyz) -----
/* SQL Analyze(715,0) */ SELECT SYS_OP_COMBINED_HASH("SUPPLIER_ID",
"SYS_NC00028$") FROM "TBX" . "SUPPLIER"
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x854991c8 1430 package body SYS.DBMS_STATS
0x854991c8 8168 package body SYS.DBMS_STATS

STACK:

Function List(to Full stack)(to Summary stack) skdstdst <- ksedst1 <- ksedst
<- dbkedDefDump <- ksedmp
<- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError
<- dbgePostErrorKGE
<- 2131 <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <-
kgerinv
<- kgeasnmierr <- kkqsfcsi <- kkqsrre <- kkqsrre <- kkqsfix
<- kkqsRewriteQB <- kkqsrqb <- kkqsRewriteCurrentQ <- kkqscqb <-
kkqsptq
<- kkqsptqur <- kkqsrdrv <- kkqdrv <- opiSem <- opiDeferredSem
<- opitca <- PGOSF634_kksFullT <- ypeCheck <- rpiswu2 <-
ypeCheck
<- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <-
kksParseCursor
<- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- kpoodrc
<- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <- kpuexec
<- OCIStmtExecute <- qksanExecSql <- qksanAnalyzeSql <- 363
<- PGOSF426_qospGetE
<- xtnName <- spefcmpa <- xtnName <- spefmccallstd <-
pextproc
<- PGOSF589_peftrust <- PGOSF633_psdexsp <- rpiswu2 <-
psdextp <- pefccal
<- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool
<- pfrrun
<- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8
<- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
<- opidrv <- sou2o <- opimai_real <- ssthrdmain

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