Re: Very slow metadata-only expdp

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


--
http://www.freelists.org/webpage/oracle-l