My Oracle Support Banner

ora-7445 [kkoitbp] running a query on a complex view (Doc ID 979442.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
Issue reproduces in 10.2.0.4 It does not reproduce in 11.1.0.x.

Symptoms

A query on a complex view fails with ora-1013. Correspondingly ORA-7445 is seen in the alertlog.


ORA-07445: exception encountered: core dump [kkoitbp()+928] [SIGSEGV] [Address not mapped to object] [0x0] [] []


kkoitbp <- kkotap <- kkoiqb <- kkooqb <- kkoqbc
apakkoqb <- apaqbdDescendents <- apaqbdListReverse <- apaqbd <- apaqbdDescendents
apaqbdListReverse <- apaqbd <- apaqbdDescendents <- apaqbdListReverse <- apaqbd
apadrv <- opitca <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc
kkspsc0 <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8
opiodr <- ttcpip <- opitsk <- opiino <- opiodr
opidrv <- sou2o <- opimai_real.........

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.