Last updated on NOVEMBER 10, 2014
Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.7This problem can occur on any platform.
Oracle Server Enterprise Edition - Version: 11.1.0.7
Symptoms
Error ORA-07445: exception encountered: core dump [kkqsterf()+660] [SIGSEGV] is reported to the instance alert.log on select statements that use a join and a connect by clause. SELECT ZZ.RESOURCE_ID ,
ZZ.PARENT_RESOURCE_ID,
ZZ.SORT_ORDER ,
ZZ.BALLOT_NUM ,
ZZ.ENTRD_BY_CUST_NUM ,
ZZ.UPDTD_BY_CUST_NUM ,
ZZ.BALLOT_COMMENT_GEN_NUM
FROM resource_usage ru
JOIN resource_repository ZZ
ON rr.resource_id = ZZ.resource_id
AND ZZ.appl_cd = 'WALK'
AND ZZ.hier_cd = 'TABBZ2'
AND ZZ.prod_cd = 'AX243'
CONNECT BY prior ZZ.resource_id = ZZ.parent_resource_id START
WITH ZZ.parent_resource_id = 36868
The call stack list in the trace file will have the following functions listed.
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd
<- kkqsterf <- kkqstrtedrv <- qksqbApplyToQbcLoc <- qksqbApplyToQbc
<- kkqdrv <- opiSem <- opiDeferredSem <- opitca <- kksFullTypeCheck
<- rpiswu2 <- kksSetBindType <- kksfbc <- opiexe <- kpoal8 <- opiodr
<- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- startCause
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