Ora-00600 [Qsmmixmergeconstructivenonovlpcols] with SQL Access Advisor (Doc ID 1343282.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Symptoms

Below error occurs when SQL Access Advisor runs

ORA-00600: internal error code, arguments: [qsmmixMergeConstructiveNonOvlpCols], [], [], [], [], [], [], [], [], [], [], []

Stack Trace:
===================================================================================
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp<- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE<- 2131 <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv
<- kgeasnmierr <- qsmmixMergeConstruc <- tiveNonOvlpCols <- qsmmixMergeConstruc <- tive<- qsmmixMergeCandidat <- qsmmixMergeCandidat <- esByTab <- qsmmixFindSimilarCa <- ndidates<- qsmmixOptimizerGenI <- dxCand <- qsmmixOptimizerSetu <- pIdxCand <- kkoiqb<- pIdxCand <- kkooqb <- kkoqbc <- apakkoqb <- apaqbdDescendents<- apaqbdList <- apaqbdDescendents <- apaqbdList <- apaqbdDescendents <- apaqbdList<- apaqbd <- apadrv <- opitca <- kksSetBindType <- kksfbc<- opiexe <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2<- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute<- qksanExecSql <- qksanAnalyzeSql <- 363 <- qsmmixProcessQuery <- qsmmixAnalyzeQuery<- qsmmcdGenerateCandi <- dates <- qsmmcdMainPPCandGen <- qsmmcdMainPPGetNext <- qsmmcdMainPP<- qsmmcdMain <- spefcmpa <- 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
<- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute<- PGOSF529_jslvec_e <- xeccb <- jslvswu <- xeccb <- jslve_execute0<- jslve_execute <- rpiswu2 <- kkjex1e <- kkjsexe <- kkjrdp<- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain<- main <- libc_start_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