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

Last updated on APRIL 17, 2023

Applies to:

Symptoms

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

Hang occurs on:

     "Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM"

.

Changes

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;

.

Cause

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