My Oracle Support Banner

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

Last updated on APRIL 07, 2020

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

Changes

 

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
Changes
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.