ORA-07445 [kkqstUnswapOpns] During Query Execution (Doc ID 1160193.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Oracle database version 11.2.0.1 , a trace file is produced with the following error, this occurs when a complex query using a LEFT OUTER JOIN is executed:

ERROR
-----------------------
ORA-07445: exception encountered: core dump [kkqstUnswapOpns()+4] [SIGSEGV] [ADDR:0x700000000000008] [PC:0x105864824] [Address not mapped to object] []

----- Call Stack Trace -----
ksedst1 <- ksedst <- dbkedDefDump <- ssexhd <- sighndlr
<- call_user_handler <- kkqstUnswapOpns <- kkqstcrf <- kkqstrtedrv <- qksqbApplyToQbcLoc
<- qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbc <- kkqdrv <- opiSem
<- opiDeferredSem <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild
<- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- 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