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 laterOracle 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
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 |