My Oracle Support Banner

EXPDP Hangs In Processing The Procedural Objects (Doc ID 1561172.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Data Pump Export hangs while unloading the system procedural objects, e.g :




under the following circumstances:

- OLAP and Workspace Manager components are installed

- SQL trace (10046 event) shows 'wait for unread message on broadcast channel' in the datapump master trace file (DM).

- Querying active sessions and review of AWR taken during export shows a spin for:
BEGIN :1 :="SYS"."DBMS_AW_EXP"."SCHEMA_INFO_EXP"(:2,:3,:4,:5,:6); END;

- Applying Patch 14192178 or Patch 11840083 do not solve this issue

- Gather system and dictionary statistics using DBMS_STATS.GATHER_SYSTEM_STATS and DBMS_STATS.GATHER_DICTIONARY_STATS do not solve this issue.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.