CAUSE

Bug 9791589 DataPump export hang / uses excessive memory with many "WITH GRANT OPTION" grants - superseded (Note 9791589.8)

Large numbers of WITH GRANT OPTION object grants can cause DataPump to run slowly and run out of memory.

Rediscovery Notes: expdp (DataPump export) appears to hang. The hang occurs with INCLUDE=OBJECT_GRANT and does not occur with EXCLUDE=OBJECT_GRANT.

E.g.:

Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
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-4030: out of process memory when trying to allocate 4032 bytes (kxs-heap-w,kghsseg : kokeismo)
ORA-06512: at "SYS.KUPW$WORKER", line 1714
ORA-06512: at line 2

Workaround:

Use EXCLUDE=OBJECT_GRANT

Note: 
This fix causes the problem described in unpublished bug 10185319. This fix is superseded by that fix.

Both fixes, both 9791589 and 10185319 must be installed to address memory leak error.

Unpublished Bug 10185319 - EXPDP not changing to PUBLIC user correctly (Note 10185319.8)

With the fix for bug 9791589 present (11.2.0.2) EXPDP may not change user to PUBLIC correctly.

Note: 
This fix is superseded by the fix for bug 10195109  Both fixes, both 9791589 and 10195109 must be installed to address memory leak error.

Bug 10195109 - ORA-4030 during datapump metadata export (Note 10195109.8)

Memory growth may be seen datapump export, e.g.:

ORA-4030: out of process memory when trying to allocate 4032 bytes (kxs-heap-w,kghsseg : kokeismo)
ORA-6512: at "SYS.KUPW$WORKER", line 1714
ORA-6512: at line 2

All are known bugs which impact datapump export processing due to excess memory usage and slow performance on metadata export.

The superseding Bug 10195109 is fixed in release 12c and patch set 11.2.0.3.
Please refer to
Note 10195109.8 - Bug 10195109 - ORA-4030 during datapump metadata export