Schema Based Expdp With Long List Of Schemas Fails With ORA-4030 Error And High Allocation Under kxs-heap-c (Doc ID 2031410.1)

Last updated on JULY 20, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.5 to 10.2.0.3 [Release 10.1 to 10.2]
Information in this document applies to any platform.

Symptoms

Using DataPump export (expdp) for a schema based export with a long list of schemas in SCHEMAS parameter, an ORA-04030 error is raised like below:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [PROCACT_INSTANCE]
ORA-04030: out of process memory when trying to allocate 217856 bytes (kxs-heap-c,temporary memory)

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x4203ef6c8     14916  package body SYS.KUPW$WORKER
0x4203ef6c8      6293  package body SYS.KUPW$WORKER
0x4203ef6c8      2339  package body SYS.KUPW$WORKER
0x4203ef6c8      6854  package body SYS.KUPW$WORKER
0x4203ef6c8      1259  package body SYS.KUPW$WORKER
0x3c67828e8         2  anonymous block


The heap dump in the trace file shows a memory leak with a high allocation under "kxs-heap-c":

---> HEAP DUMP heap name="top call heap"  desc=0x674c420
              Type           Count             Sum         Average
              ~~~~           ~~~~~             ~~~         ~~~~~~~
              free           53859      2276504008        42267.85
          freeable          173309     12067624424        69630.69
              perm               1            1520         1520.00
          recreate               4           19744         4936.00

BreakDown
~~~~~~~~~
              Type           Count             Sum         Average Percent
              ~~~~           ~~~~~             ~~~         ~~~~~~~ ~~~~~~~
   Free(heap.awk)            53859      2276504008        42267.85  15.87
   kxs-heap-c                68718     11492717704       167244.65  80.12
   callheap                 104594       574926256         5496.74   4.01


---> HEAP DUMP heap name="kxs-heap-c"  desc=0x2b648fdf0160
              Type           Count             Sum         Average
              ~~~~           ~~~~~             ~~~         ~~~~~~~
              perm           51435     11206990736       217886.47
              free           12967        17633488         1359.87
          freeable          242042       265344736         1096.28

BreakDown
~~~~~~~~~
              Type           Count             Sum         Average Percent
              ~~~~           ~~~~~             ~~~         ~~~~~~~ ~~~~~~~
   perm                      51435     11206990736       217886.47  97.54
   Free(heap.awk)            12967        17633488         1359.87   0.15
   qkkele                   121012       258481632         2136.00   2.25
   qkkkey                   121012         6845936           56.57   0.06

---> HEAP DUMP heap name="callheap"  desc=0x2b648fdfa600
              Type           Count             Sum         Average
              ~~~~           ~~~~~             ~~~         ~~~~~~~
          freeable          104588       570671744         5456.38
          recreate               1             840          840.00

BreakDown
~~~~~~~~~
              Type           Count             Sum         Average Percent
              ~~~~           ~~~~~             ~~~         ~~~~~~~ ~~~~~~~
   Typecheck                104588       570672376         5456.38 100.00
   Typecheck heap                1             208          208.00   0.00

---> HEAP DUMP heap name="Typecheck"  desc=0x2b648fdf0c00
              Type           Count             Sum         Average
              ~~~~           ~~~~~             ~~~         ~~~~~~~
              free           54919         7583760          138.09
          freeable         1648381       558905072          339.06

BreakDown
~~~~~~~~~
              Type           Count             Sum         Average Percent
              ~~~~           ~~~~~             ~~~         ~~~~~~~ ~~~~~~~
   Free(heap.awk)            54919         7583760          138.09   1.34
   seg:kggfaAllocS           80195       321532392         4009.38  56.76

 

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