My Oracle Support Banner

ORA-7445 [KKQSTERF()+744] [SIGSEGV] On Select With Connect By (Doc ID 784896.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.
Oracle Server Enterprise Edition - Version:


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.

  ZZ.SORT_ORDER        ,
  ZZ.BALLOT_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 <- start


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

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