ORA-600 [12442] FROM SQL ADVISOR (Doc ID 1071115.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

In Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
The following error is dumped:

file: /usr/local/oracle/log/diag/rdbms/devcdi0/devcdi02/trace/devcdi02_j002_8771.trc
ORA-00600: internal error code, arguments: [12442], [], [], [], [], [], [], [], [], [], [], []

in the trace file


/* SQL Analyze(101,1) */ SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM2) SYNNAM2, DBMS_JAVA.LONGNAME(SYNTAB) SYNTAB, TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SYS.EXU9PTS ORDER BY SYNTIME


STACK TRACE :
---------

ksedst1 <- ksedst <- dbkedDefDump <- dbgexPhaseII <- dbgexProcessError
<- dbgePostErrorKGE <- 1128 <- kgeade <- kgeriv_int <- kgesiv
<- ksesic0 <- msqopnws <- msqbin <- k2copnws <- msqant
<- msq_logical <- msqsel <- qksdsAppendFroElem <- qksdsEInitCtx <- kkoatVerifyEst
<- kkeAdjJoinPrefCard <- kkejcd <- kkojnp <- kkocnp <- kkooqb
<- kkoqbc <- apakkoqb <- apaqbdDescendents <- apaqbd <- kkqctdrvJPPD
<- kkqjpdctr <- qksqbApplyToQbcLoc <- qksqbApplyToQbc <- kkqctdrvTD <- kkqjpddrv
<- kkqdrv <- kkqctdrvIT <- apadrv <- opitca <- kksFullTypeCheck
<- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0
<- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr
<- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc
<- kpuexec <- OCIStmtExecute <- qksanAnalyzeSql <- 196 <- qksanAnalyzeSegSql
<- kestsaDoRounds <- kestsaAutoTuneSql <- kestsaAutoTuneDrv <- kestsTuneSqlDrv <- kesaiExecAction
<- kesaiTuneSqlDrv <- 344 <- spefcifa <- spefmccallstd <- peftrusted
<- psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal
<- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run
<- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr
<- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute
<- jslvec_execcb <- jslvswu <- jslve_execute0 <- jslve_execute <- rpiswu2
<- kkjex1e <- kkjsexe <- kkjrdp <- opirip <- opidrv
<- sou2o <- main <- start



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