Expdp Performance Problem With DATABASE_EXPORT/SCHEMA/JOB (Doc ID 1675935.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Datapump export is slow during following actions involving jobs:

Processing object type DATABASE_EXPORT/SCHEMA/JOB
    Completed 2 JOB objects in 16522 seconds


Trace datapump worker (DW) shows that the longest time is spent in following: 

BEGIN :1 :="SYS"."DBMS_SCHED_JOB_EXPORT"."CREATE_EXP"(:2,:3,:4); END;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       23      0.00       0.00          0          0          0           0
Execute 2842534    510.79    1141.23          0    6460296    5685287     8527602
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   2842557    510.79    1141.23          0    6460296    5685287     8527602

Cause

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 hundreds of Community platforms