ORA-4030 caused by a Memory Leak in the Capture Builder Process (Doc ID 789465.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.8 - Release: 9.2 to 9.2
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4   [Release: 10.2 to 10.2]
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7   [Release: 11.1 to 11.1]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 9.2.0.1.0 to 9.2.0.8.0
Oracle Server Enterprise Edition - Version: 10.2.0.1.0 to 10.2.0.4.0
Oracle Server Enterprise Edition - Version: 11.1.0.6.0 to 11.1.0.7.0

Symptoms

The Capture builder process exhibits a memory leak of about 1MB per hour which eventually leads to
an ORA-4030.

Using the the relevant builder spid from

connect / as sysdba

select lp.spid, p.pga_alloc_mem from v$logmnr_process lp, v$process p where lp.spid=p.spid and lp.role = 'builder' order by p.pga_alloc_mem;

or from the information reported in the alert.log from the relevant Capture process startup detailed PGA heapdumps generated via

oradebug setospid <relevant spid from above>

oradebug unlimit

oradebug dump heapdump 536870913

--wait 10 minutes

oradebug dump heapdump 536870913

--wait 10 minutes

oradebug dump heapdump 536870913

oradebug tracefile_name

oradebug close_trace

show a growth in the 'free' component of memory associated with krvxiphd: priv, e.g.,

---> HEAP DUMP heap name="krvxiphd: priv" desc=3F746FA8
Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
free 645 186154424 288611.51
freeable 1450 288336 198.85

BreakDown
~~~~~~~~~
Type Count Sum Average Percent
~~~~ ~~~~~ ~~~ ~~~~~~~ ~~~~~~~
Free(heap.awk) 645 186154424 288611.51 99.85
krvrd-pCachedOb 1416 218092 154.02 0.12
krvrd-pCachedTc 4 8768 2192.00 0.00
krvrdCBmddlSQL 10 24440 2444.00 0.01
krvuatlas 14 7856 561.14 0.00
krvrdCBmddlSQL: 1 96 96.00 0.00
krvrd-kprbCtx 1 1580 1580.00 0.00
krvrd-ProcDictC 1 2244 2244.00 0.00
krvtinit 2 25120 12560.00 0.01
krvuatlau 1 140 140.00 0.00

Total = 186442760 bytes 182073.01k 177.81MB

---> HEAP DUMP heap name="krvxiphd: priv" desc=3F746FA8
Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
free 675 207412544 307277.84
freeable 1494 295112 197.53

BreakDown
~~~~~~~~~
Type Count Sum Average Percent
~~~~ ~~~~~ ~~~ ~~~~~~~ ~~~~~~~
Free(heap.awk) 675 207412544 307277.84 99.86
krvrd-pCachedOb 1460 224868 154.02 0.11
krvrd-pCachedTc 4 8768 2192.00 0.00
krvrdCBmddlSQL 10 24440 2444.00 0.01
krvuatlas 14 7856 561.14 0.00
krvrdCBmddlSQL: 1 96 96.00 0.00
krvrd-kprbCtx 1 1580 1580.00 0.00
krvrd-ProcDictC 1 2244 2244.00 0.00
krvtinit 2 25120 12560.00 0.01
krvuatlau 1 140 140.00 0.00

Total = 207707656 bytes 202839.51k 198.09MB

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