My Oracle Support Banner

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

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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

Changes

 

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


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