DataPump Worker (DW) Process Causing Memory Leak In "kuxLpxAlloc" Leading To ORA-04030
(Doc ID 2260761.1)
Last updated on MARCH 27, 2019
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]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
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
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
...
---------------------------------------
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
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 |