ORA-00600: Internal Error Code, Arguments: [qesdpSigError] (Doc ID 2145496.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

Running a query fails with error:

ORA-00600: internal error code, arguments: [qesdpSigError], [adaptive join resolution failed], [26], [], [], [], [], [], [], [], [], []

Call stack trace is similar to:


qesdpSigError <- qerjoResolveDynamic <- qerjoFetch <- qerbuFetch <- kdibr1sf
<- qerbaFndOl <- qerbaStrmAnd <- qerbaFetch <- kdibr1sf <- qerbtFetch
<- qertbFetchByRowID <- rwsfcd <- qerhjFetch <- qerjotFetch <- qerscFetchBuffer
<- qerscFetch <- qerjoResolveDynamic <- qerjotFetch <- qerjoResolveDynamic
<- qerjotFetch <- rwsfcd <- qerhjFetch <- qerghFetch <- opifch2
<- opifch <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain

 

Parameter optimizer_adaptive_features is set to TRUE.

 

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