My Oracle Support Banner

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

Last updated on MARCH 04, 2020

Applies to:

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

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

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
Symptoms
Changes
Cause
Solution
References


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