My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.