DataPump Export (EXPDP) Terminates With Error ORA-4030

(Doc ID 1368462.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2014***

Symptoms

Expdp terminates with error ORA-4030:

...
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TYPE:"SYSMAN"."MGMT_CONTAINER_CRED_ARRAY"]
ORA-04030: out of process memory when trying to allocate 4128 bytes (kxs-heap-w,kghsseg : kokeismo)

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

----- PL/SQL Call Stack -----
object line object
handle number name
0x2bda5f7d0 15032 package body SYS.KUPW$WORKER
0x2bda5f7d0 6372 package body SYS.KUPW$WORKER
0x2bda5f7d0 2396 package body SYS.KUPW$WORKER
0x2bda5f7d0 6944 package body SYS.KUPW$WORKER
0x2bda5f7d0 1314 package body SYS.KUPW$WORKER
0x2babf1d00 2 anonymous block

Job "SYSTEM"."SYS_EXPORT_FULL_05" stopped due to fatal error at 09:46:56

The trace file during the time of the error shows the below statement ran on the object SYS.KU$_PROCACT_SYS_VIEW:

SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('PROCACTSYS_T', '7')), 0 ,'SYSTEM' ,'PROCACT_SYSTEM' FROM SYS.KU$_PROCACT_SYS_VIEW KU$ WHERE KU$.PLSQL IS NOT NULL AND  KU$.PREPOST=0

The event:

connect / as sysdba
alter system set events '4030 trace name heapdump level 536870917; name errorstack level 3';

was set and the trace file shows the maximum size taken by the chunk kxs-heap-w perm and koh-kghu sessi under the sub chunk pl/sql vc2:

---> HEAP DUMP heap name="top uga heap" desc=0x6902960

Type     Count Sum        Average
~~~~~~~~ ~~~~~ ~~~~~~~~~~ ~~~~~~~
free     65500    5240544 80.01
freeable 65515 4286712968 65431.02
recreate     1      65432 65432.00

BreakDown
~~~~~~~~~
Type           Count Sum        Average  Percent
~~~~~~~~~~~~~~ ~~~~~ ~~~~~~~~~~ ~~~~~~~~ ~~~~~~~
Free(heap.awk) 65500    5240544    80.01    0.12
session heap   65516 4286778400 65431.02   99.88

---> HEAP DUMP heap name="session heap" desc=0x7f305b076308

Type     Count Sum         Average
~~~~~~~~ ~~~~~ ~~~~~~~~~~~ ~~~~~~~
free      65562  214131672 3266.09
freeable 628983 4069368744 6469.76
recreate    395     442192 1119.47
perm         30     215128 7170.93

BreakDown
~~~~~~~~~
Type            Count Sum        Average  Percent
~~~~~~~~~~~~~~ ~~~~~~ ~~~~~~~~~~ ~~~~~~~~ ~~~~~~~
Free(heap.awk)  65562  214131672  3266.09    5.00
kxs-heap-w     508523 2119534176  4168.02   49.47
koh-kghu sessi 118571 1947316992 16423.21   45.45
..

---> HEAP DUMP heap name="kxs-heap-w" desc=0x7f305af7a6f8

Type     Count  Sum        Average
~~~~~~~~ ~~~~~~ ~~~~~~~~~~ ~~~~~~~
perm     508521 2099178624 4128.01
freeable     14       9896 706.86
recreate      2       4712 2356.00

BreakDown
~~~~~~~~~

Type Count  Sum        Average Percent
~~~~ ~~~~~~ ~~~~~~~~~~ ~~~~~~~ ~~~~~~~
perm 508521 2099178624 4128.01 100.00 <== HIGH
..
..

---> HEAP DUMP heap name="koh-kghu sessi" desc=0x7f305a52b560

Type     Count Sum        Average
~~~~~~~~ ~~~~~ ~~~~~~~~~~ ~~~~~~~
freeable 78297 1284662360 16407.56
free         1       1048 1048.00

BreakDown
~~~~~~~~~

Type         Count Sum        Average  Percent
~~~~~~~~~~~~ ~~~~~ ~~~~~~~~~~ ~~~~~~~~ ~~~~~~~
pmucalm coll  5697   93464088 16405.84    7.28
pl/sql vc2   71510 1173327888 16407.89   91.33 <== HIGH
..

 

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