My Oracle Support Banner

Datapump Metadata Export Is Running Slow (Doc ID 2002518.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

11.2.0.3 DataPump export with CONTENT=METADATA_ONLY takes a lot of time to finish.
The performance issue is hit even if PSU 11.2.0.3.12 and Merge Patch 20239832 are installed in order to have all the known performance issues fixed on the system:

Patch  19769496     : applied on Tue Mar 31 13:23:36 CDT 2015
Patch  19877443     : applied on Tue Mar 31 13:54:58 CDT 2015

Patch  20239832     : applied on Tue Mar 31 14:50:58 CDT 2015
                          Unique Patch ID:  18403010
                            Created on 19 Dec 2014, 20:40:22 hrs PST8PDT
                                Bugs fixed:
                                  13573203, 13714302, 12780993, 10649822, 13844935, 18793246, 13979927
                                  12325243, 14192178
Patch  19008464     : applied on Tue Mar 31 14:21:20 CDT 2015


* CDC is enabled on this database:

 

Changes

 There are not changes in the environment.

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.