My Oracle Support Banner

Data Pump Export Is Very Slow While Exporting Constraints and Tracing Shows SQL_ID='d1nmmj208r1wz' as the Problem SQL (Doc ID 3072984.1)

Last updated on FEBRUARY 24, 2025

Applies to:

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

Symptoms

Data Pump export is slow, and inspection of the export log shows that the objects being exported at the time of slowness are constraints.

Investigating via gv$session, it can be seen that the problem SQL is sql_id=d1nmmj208r1wz:

 

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.