ORA-600 [723], [136048], [1213795928], [memory Leak] when Running a Spatial Query (Doc ID 2350795.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Symptoms

On 12.1.0.2, the following error was reported in the alert log when running a Spatial query:

ORA-00600: internal error code, arguments: [723], [140904], [195968], [memory leak], [], [], [], [], [], [], [], []

The trace file shows the leak is in "mdorelOutputRing"

========================================
SUMMARIZED MEMORY USAGE FOR THIS PROCESS
----------------------------------------
34337704 bytes, 127 chunks: "free memory "
top uga heap ds=0x7fec27e5ddc0 dsprt=(nil)
17102032 bytes, 79 chunks: "free memory "
pga heap ds=0x7fec27e579a0 dsprt=(nil)
1287448 bytes, 48 chunks: "permanent memory "
pga heap ds=0x7fec27e579a0 dsprt=(nil)
263256 bytes, 3 chunks: "permanent memory "
top call heap ds=0x7fec27e5dba0 dsprt=(nil)
260984 bytes, 1 chunk : "free memory "
top call heap ds=0x7fec27e5dba0 dsprt=(nil)
189344 bytes, 42 chunks: "mdorelOutputRing:c "
pga heap ds=0x7fec27e579a0 dsprt=(nil)
4352 bytes, 1 chunk : "mdrcncColumnNameCache "
pga heap ds=0x7fec27e579a0 dsprt=(nil)
2088 bytes, 1 chunk : "mdcsWktCache "
pga heap ds=0x7fec27e579a0 dsprt=(nil)
184 bytes, 1 chunk : "heap_kdlipga "
pga heap ds=0x7fec27e579a0 dsprt=(nil)
112 bytes, 1 chunk : "permanent memory "
top uga heap ds=0x7fec27e5ddc0 dsprt=(nil)

******************************************************
HEAP DUMP heap name="pga heap" desc=0x7fec27e579a0
extent sz=0x20c0 alt=240 het=32767 rec=0 flg=3 opc=3
parent=(nil) owner=(nil) nex=(nil) xsz=0xffff0 heap=(nil)
fl2=0x60, nex=(nil), dsxvers=1, dsxflg=0x0
dsx first ext=0x7fec23706b60
dsx empty ext bytes=5800416 subheap rc link=0x7fec23706bd0,0x7fec23706bd0
pdb id=0
EXTENT 0 addr=0x7fec1e100010
Chunk 7fec1e100020 sz= 1048544 free " "
EXTENT 1 addr=0x7fec1e0c0010
Chunk 7fec1e0c0020 sz= 5016 free " "
Chunk 7fec1e0c13b8 sz= 10712 freeable "mdorelOutputRin"

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.