Re: expdp performance

Posted by ErmanArslansOracleBlog on Sep 27, 2022; 6:04pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/expdp-performance-tp11099p11101.html

It may be caused by repeated queries, for checking objects to export, for calculating things like Estimated Times and etc..

The thing that makes me think that way is the faster full export.. This means when you do things in one go, it completes faster.. So, probably there is something other than export itself.. its queries, its checks and etc..

Still, you have a workaround.. Full export is not a bad thing ( and you got lots of schema to export) :)

If I were you, I would monitor database sessions of those export processes + I would check the following MOS notes ->

Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp) (Doc ID 453895.1)
DataPump Export (EXPDP) Performance Known Problems (Doc ID 1941760.1)