A datapump worker dies with error ORA-04030 while importing statistics.
SYMPTOMPS

A datapump import failed with the following error

impdp system/password schemas=XXCDB NETWORK_LINK=PRODDB DIRECTORY=DROPZONE LOGFILE=logfile.log
...
Processing object type SCHEMA_EXPORT/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 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
Processing object type SCHEMA_EXPORT/JOB
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA

There are sufficient SGA/PGA in the database.

SOLUTION

To eliminate the error with a datapump worker, exclude statistics during an import

impdp system/password schemas=XXCDB NETWORK_LINK=PRODDB DIRECTORY=DROPZONE LOGFILE=logfile.log EXCLUDE=STATISTICS
NOTE

It skips tables statistics but collects indexes statistics.

 
When the import is completed, manually gather schema statistics by executing the DBMS_STATS.GATHER_SCHEMA_STATS procedure

EXEC DBMS_STATS.GATHER_SCHEMA_STATS('XXCDB');
REFERENCES

EXCLUDE=STATISTICS Or EXCLUDE=INDEX_STATISTICS During Datapump Import Still Analyzes The Indexes (Doc ID 793585.1)

Written At
22 JULY 202016:40
OEL Release
7.2 x64
Database Release
11.2.0.4