Data Pump Import Encountering ORA-04030 (session heap,kuxLpxAlloc)
(Doc ID 1516766.1)
Last updated on OCTOBER 08, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_dw00_21842.trc (incident=96666):
ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)
Incident details in: /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_96666/<sid>_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 /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_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: /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_96667/<sid>_dw00_21842_i96667.trc
Errors in file /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_dw00_21842.trc (incident=96666):
ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)
Incident details in: /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_96666/<sid>_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 /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_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: /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_96667/<sid>_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
=======================================
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
=======================================
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |