My Oracle Support Banner

Datapump Export (EXPDP) hangs on PROCACT_SCHEMA (Doc ID 2640717.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 19]
Information in this document applies to any platform.


EXPDP hangs for long periods of time and possibly never completes.

Hang occurs on:




Troubleshooting steps:

1.  Get 10046 trace of the datapump job.

      Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump (Doc ID 286496.1)

      How To Use The New 11g Events++ Syntax For Easier SQL Tracing Of Datapump Operations? (Doc ID 813737.1)

2.  A review of the trace output should show the DW00 worker with many waits in queries to DBA_AUTOTASK_OPERATION

3.  The test to confirm this would be to perform the following query to see if this also hangs.

     select client_name, operation_name, status, attributes, priority_override, TO_CHAR(NULL)
      from dba_autotask_operation
     where last_change IS NOT NULL
     union all
     select client_name, NULL, status, attributes, priority_override, NVL(service_name, 'NULL')
      from dba_autotask_client
      where last_change IS NOT NULL
     union all
     select distinct NULL, NULL, status, NULL, NULL, TO_CHAR(NULL)
      from dba_autotask_status
      where last_change IS NOT NULL;




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

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

In this Document

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