DataPump Worker (DW) Process Causing Memory Leak In "kuxLpxAlloc" Leading To ORA-04030 (Doc ID 2260761.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

DataPump DW process hits ORA-04030 error when loading the table_statistics:

...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
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
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
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
Job "SYS"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 23:07:47


As one can see from the DW trace file, ORA-04030 error is due to excessive memory allocation in "kuxLpxAlloc" structure:

TOP 10 MEMORY USES FOR THIS PROCESS
 ---------------------------------------
96% 18 GB, 17710913 chunks: "kuxLpxAlloc "
session heap ds=0x7f8a4967e6b0 dsprt=0x7f8a49b0fa80
3% 545 MB, 1129670 chunks: "free memory "
session heap ds=0x7f8a4967e6b0 dsprt=0x7f8a49b0fa80
...

 

Changes

NONE

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