Data Pump Import Of Large Tables Fails with ORA-4030 (session heap,kuxLpxAlloc) Errors Even After Patch 6051734 Has Been Applied (Doc ID 1088111.1)

Last updated on JULY 25, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

During data pump import of a large dump, the following error messages are seen:

ORA-4030: out of process memory when trying to allocate 65584 bytes (session heap,kuxLpxAlloc)

Current SQL statement for this session:
BEGIN
   SYS.KUPW$WORKER.MAIN('SYS_IMPORT_FULL_14', 'SYSTEM');
END;


If performing a Transportable Tablespace import (TTS) the error will look similar to:

ORA-04030: out of process memory when trying to allocate 112048 bytes (session heap,kuxLpxAlloc)

Current SQL statement for this session:
 BEGIN
   SYS.KUPW$WORKER.MAIN('SYS_SQL_FILE_TRANSPORTABLE_10', 'SYS');
 END;

Stack trace will show similar to:

ksedst <- ksedmp <- ksddoa <- ksdpec <- ksfpec <- kgesev <- kgesec3 <- kghnospc <- kghalf <- kuxLpxAlloc <- OraMemAlloc <- LpxMemNewDoleBlock


The heap dump will show a large consumption in the kuxLpxAlloc sub-heap.

For example:


---> HEAP DUMP heap name="session heap"  desc=ffffffff7a6285b8

Type Count Sum Average
 ~~~~ ~~~~~ ~~~ ~~~~~~~
free 2699 2597600 962.43
freeable 21817 1397061456 64035.45
perm 88 237680 2700.91
recreate 176 226656 1287.82
 .
 BreakDown
 ~~~~~~~~~
 Type                    Count             Sum         Average Percent
 ~~~~ ~~~~~ ~~~ ~~~~~~~ ~~~~~~~
Free(heap.awk) 2699 2597600 962.43 0.19
kuxLpxAlloc               20690      1392046464        67281.12  99.42  <<<----Leak
kgbt 2 80 40.00 0.00
perm 88 237680 2700.91 0.02
koh-kghu sessi 233 3228432 13855.93 0.23
koh-kghu sessio 87 216792 2491.86 0.02
..
Total = 1400123392 bytes      1367308.00k         1335.26MB


Changes

You have already applied <> (if on 10.2.0.4), or upgraded to the 10.2.0.5 or 11.1.0.7 release but the errors still persist.

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