Ora-00600 [Qsmmixmergeconstructivenonovlpcols] with SQL Access Advisor
(Doc ID 1343282.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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
===================================================================================
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |