Thanks for your feedback.
We currently have an Oracle SR, and they tried us to apply a few patches, but
none of them have helped so far.
Is it possible for someone in this community to try an export similar to below
and provide their findings? It probably needs to be at least a decent size
large system for the issue to reproduce.
For our tests, we've been using ~3TB DB and we see the slowness, but the real
requirement is on a ~160TB prod DB.
expdp userid=system/<passwd> DIRECTORY=DP_DIR LOGFILE=expdp_CONSTRAINT_ONLY.log
DUMPFILE=expdp_CONSTRAINT_ONLY.dmp FULL=y METRICS=Y CONTENT=METADATA_ONLY
INCLUDE=CONSTRAINT
-Thanks in advance
On Thursday, October 20, 2016 11:12 PM, Mladen Gogala
<gogala.mladen@xxxxxxxxx> wrote:
There are several bugs listed in the master note:
https://blogs.oracle.com/db/entry/master_note_for_data_pump_doc_id_12647151
Also, when you google for "oracle expdp slow", you will get a lot of hits, one
of them from always helpful Mike Dietrich:
https://blogs.oracle.com/UPGRADE/entry/data_pump_imdp_over_network
It is worth researching some of those hits, since they come from some very
good people. Also, the problem may be in using wrong plans when accessing SYS
tables. When exporting metadata only, you are only accessing SYS tables. Try
running data dictionary statistics and gather system statistics. That may help.
Regards
On 10/19/2016 04:12 PM, Deepak Sharma (Redacted sender sharmakdeep_oracle for
DMARC) wrote:
I guess I should rephrase the real issue wrt the export of metadata.
expdp userid=system/<passwd> DIRECTORY=DP_DIR LOGFILE=expdp_CONSTRAINT_ONLY.log
DUMPFILE=expdp_CONSTRAINT_ONLY.dmp FULL=y METRICS=Y CONTENT=METADATA_ONLY
INCLUDE=CONSTRAINT
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217