Data Pump Import Encountering ORA-04030 (session heap,kuxLpxAlloc) (Doc ID 1516766.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

During data pump import (impdp) of large database which contains large partitioned tables and many sub-partitions, the import will fail with ORA-4030 errors.

Thu Dec 20 05:19:27 2012
Errors in file /u01/app/oracle/diag/rdbms/dmstr/DMSTR/trace/DMSTR_dw00_21842.trc (incident=96666):
ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)
Incident details in: /u01/app/oracle/diag/rdbms/dmstr/DMSTR/incident/incdir_96666/DMSTR_dw00_21842_i96666.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Dec 20 05:22:20 2012
Dumping diagnostic data in directory=[cdmp_20121220052220], requested by (instance=1, osid=21842 (DW00)), summary=[incident=96666].
Thu Dec 20 05:22:21 2012
Errors in file /u01/app/oracle/diag/rdbms/dmstr/DMSTR/trace/DMSTR_dw00_21842.trc (incident=96667):
ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
Incident details in: /u01/app/oracle/diag/rdbms/dmstr/DMSTR/incident/incdir_96667/DMSTR_dw00_21842_i96667.trc

 

From the trace file, we can see excessive use of the  "kuxLpxAlloc" area of the private memory:

=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** 2012-12-20 05:20:27.507
94%   13 GB, 962358 chunks: "kuxLpxAlloc               "     <<<<<<<----------------
        session heap    ds=ffffffff78f36cf0  dsprt=10d00ddf0
6%  764 MB, 73160 chunks: "free memory               "  
        top uga heap    ds=10d00ddf0  dsprt=0
0%   43 MB, 64268 chunks: "free memory               "  
        session heap    ds=ffffffff78f36cf0  dsprt=10d00ddf0
0%   22 MB, 1399 chunks: "pmuccst: adt/record       "  PL/SQL
        koh-kghu sessi  ds=ffffffff77430cd0  dsprt=ffffffff78f36cf0
0% 6406 KB,  45 chunks: "free memory               "  
        pga heap        ds=10d007f30  dsprt=0
0% 2135 KB,   2 chunks: "kgh stack                 "  
        pga heap        ds=10d007f30  dsprt=0
0% 1833 KB, 115 chunks: "pmucalm coll              "  PL/SQL
        koh-kghu sessi  ds=ffffffff77430cd0  dsprt=ffffffff78f36cf0
0% 1037 KB,  21 chunks: "kpmalloc                  "  
        koh-kghu sessi  ds=ffffffff7df79670  dsprt=ffffffff78f36cf0
0% 1001 KB,  39 chunks: "static frame of inst      "  PL/SQL
        koh-kghu sessi  ds=ffffffff6f2cf660  dsprt=ffffffff78f36cf0
0%  737 KB,  33 chunks: "recursive addr reg file   "  PL/SQL
        koh-kghu sessi  ds=ffffffff6f000748  dsprt=ffffffff78f36cf0

=======================================

 

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