XML Query using XMLELEMENT, XMLFOREST Fails with ORA-7445 [Kkscompileheapstats()+69] in 11.2.0.3 (Doc ID 1401261.1)

Last updated on DECEMBER 18, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

After upgrading the database to 11.2.0.3, a query that uses the XML functions XMLELEMENT, XMLATTRIBUTES, XMLFOREST and XMLAGG now fails with the following error:

ORA-07445: exception encountered: core dump [kksCompileHeapStats()+69] [SIGSEGV] [ADDR:0x7FFF61191FF8] [PC:0x8A755AB] [Address not mapped to object] []

The stack trace in the trace file has the following function calls:

----- Call Stack Trace -----
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd <- sighandler <- kksCompileHeapStats <- kghalf  <- kghalp <- qctoxop <- qctcopn <- qctcopn
<- qmxtgr2TypeCheck <- qmxtcTypeCheckOpn2 <- qmxtr2InitNewOp <- qmxtr2XFC2CXE <- qmxtr2oxmlcolelem <- kokqbpt <- kokqbpt <- kokqbpt <-kokqbpt <- kokqbpt ...
**** At frame 60 recursion pattern of size 2 found, for return address
kokqbpt()+436 suppressing printing.

The following errors may also be encountered:

ORA-4030: out of process memory when trying to allocate 184 bytes (qksqb.c.kgght)
ORA-4030: out of process memory when trying to allocate 112 bytes (optdef: qcopCreateOptInternal)

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