Datapump Metadata Export Is Running Slow (Doc ID 2002518.1)

Last updated on MAY 31, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
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

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