My Oracle Support Banner

Expdp is Very Slow Whyle Exporting A Large Number of Constraints (Doc ID 3059468.1)

Last updated on NOVEMBER 25, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.23.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Symptoms

DataPump export operation is slow and the tkprof output of the process shows the most of the time is consumed while running following query:

 

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
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.