APPLIES TO:

Oracle? Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Feb-2016***

SYMPTOMS

Linux x86-64 running standard edition 11.2.0.2 with RAC reporting slow performance on expdp for object_grants.

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

SOLUTION

To solve the issue,use any of below alternatives:

o? Upgrade to 12c

- OR -

o? Apply patch set 11.2.0.3 or higher

- OR -

o? Apply interim?Patch 10195109?if available for your platform and (PSU) patch level

?? To check for conflicting patches,please use the MOS Patch Planner Tool
?? Please refer to
???Note 1317012.1?- How To Use MOS Patch Planner To Check And Request The Conflict Patches?

REFERENCES

BUG:10195109?- ORA-4030 DURING DATAPUMP METADATA EXPORTNOTE:10185319.8?- Bug 10185319 - EXPDP not changing to PUBLIC user correctly - supercededNOTE:10195109.8?- Bug 10195109 - ORA-4030 during datapump metadata exportNOTE:1267951.1?- DataPump Import (IMPDP) is Very Slow at Object/System/Role Grants,Default RolesNOTE:9791589.8?- Bug 9791589 - Data Pump export hang / uses excessive memory with many "WITH GRANT OPTION" grants - superceded

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!