ORA-04030: out of process memory when trying to allocate 8200 bytes (OLAP stack hea,OLAP Stack Seg)

Last updated on APRIL 04, 2018

Applies to:

Symptoms

ORA-04030: out of process memory when trying to allocate 49160 bytes (OLAP PGA Stack,xspg_drefs)
ORA-07445: exception encountered: core dump [xsStkPop()+46] [SIGSEGV] [ADDR:0x0] [PC:0x359A544] [Address not mapped to object] []
ORA-04030: out of process mem

Details for: incident_dump: ========= Dump for incident 734854 (ORA 4030) ========
========= Dump for incident 734854 (ORA 4030) ========
----- Beginning of Customized Incident Dump(s) -----
=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** 2018-03-05 12:45:22.437
87% 3546 MB, 453410 chunks: "OLAP Stack Seg " OLAP
  OLAP stack hea ds=0x7f8bb7383ec0 dsprt=0x7f8bb7384e30
11% 466 MB, 64788 chunks: "free memory "
  pga heap ds=0xc160920 dsprt=(nil)
 0% 14 MB, 253 chunks: "permanent memory " OLAP
  MOLAP chunk he ds=0x7f8bb66d3fd0 dsprt=0x7f8bb73a4a18
 0% 12 MB, 192 chunks: "OLAP Page Pool " OLAP
  OLAP UGA heap ds=0x7f8bb73a4a18 dsprt=0x7f8bb73bd3a8
 0% 3255 KB, 29758 chunks: "xslob " OLAP
  MOLAP chunk he ds=0x7f8bb66d3fd0 dsprt=0x7f8bb73a4a18
 0% 1960 KB, 6888 chunks: "OLAP PGSET:Array " OLAP
  OLAP btree hea ds=0x7f8bb73a4c20 dsprt=0x7f8bb73bd3a8
 0% 1639 KB, 5119 chunks: "xsobj " OLAP
  OLAP TRAN Zone ds=0x7f8bb73a4d68 dsprt=0x7f8bb73bd3a8
 0% 1213 KB, 15061 chunks: "xsdimich " OLAP
  xsdimich ds=0x7f8bb3380950 dsprt=0x7f8bb73a4a18
 0% 1083 KB, 1631 chunks: "OLAP xspsmcache ptr " OLAP
  MOLAP chunk he ds=0x7f8bb66d3fd0 dsprt=0x7f8bb73a4a18
 0% 964 KB, 8 chunks: "kllcqas:kllsltba " SQL
  QERGH hash-agg ds=0x7f8bb58ab598 dsprt=0x7f8bb73bcc60

Function List (to Full stack) (to Summary stack)

mmap <- mmap <- mmap <- mmap <- mmap
<- mmap <- mmap <- mmap <- mmap <- mmap
<- mmap <- mmap <- mmap <- mmap <- mmap
<- mmap <- mmap <- skdstdst <- ksedst1 <- ksedst
<- dbkedDefDump <- ksedmp <- 0000000004C036E9 <- 0000000008945EA4 <- dbgexExplicitEndInc
<- 0000000008903639 <- dbgeEndDDEInvocatio <- 0000000002D72C4E <- kghalf <- xsStkPos
<- xsVCCopy <- xsdhRCheck <- xsCGetVal <- xsSvnToVC <- 00000000036CC7C8
<- 00000000036D0790 <- 00000000036CD8A5 <- xsXEQ <- xsEXECUT <- xsGETXVAL
<- 00000000033C4C71 <- 00000000033C48E0 <- mmap <- mmap <- xsqerAWGetNextRecor
<- qerawFetch <- qerghFetch <- qervwFetch <- qerwnFetch <- qervwFetch
<- qersoProcessULS <- qersoFetch <- qervwFetch <- qercoFetch <- opifch2
<- opifch <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain
<- main <- libc_start_main <- 0000000000A2A1C9

Cause