Data Pump export hang / uses excessive memory with many "WITH GRANT OPTION" grants superceded
This note gives a brief overview of bug 9791589. Click here for details of each of the sections below.
Affects Oracle Server (Rdbms) BELOW v12.1 on all platforms.
Note that this fix can cause / expose the problem described in Bug:10185319
Note that this fix has been superceded by the fix in Bug:10195109
This issue is fixed in 12.1.0.1 (Base Release)
Symptoms
- Error May Occur
- Hang (Process Hang)
- Leak (Memory Leak / Growth)
- ORA-4030
Related To
- Datapump Export/Import
Description
Large numbers of WITH GRANT OPTION object grants can cause Data Pump to run slowly and run out of memory.
Rediscovery Notes:
expdp (Data Pump export) appears to hang. The hang occurs with
INCLUDE=OBJECT_GRANT and does not occur with EXCLUDE=OBJECT_GRANT.
eg:
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