Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datapump: expdp taking considerably longer than exp

802349Dec 18 2010 — edited Dec 29 2010

does anyone know why datapump export takes considerably longer than the deprecated exp function of oracle?

with few schemes datapump is rather fast. the more schemes you have, the longer it takes for datapump to perform an export. the deprecated exp function however remains fast.

some statistics i've made:

12 schemes: export takes ~30 seconds
128 schemes: export takes ~60 seconds
152 schemes: export takes ~80 seconds
328 schemes: export takes ~ 5minutes(!)

after i deleted schemes and reduced the number of schemes to 68, the expdp function became fast again: ~60 seconds.

does anyone have a hint for me about where i can make performance modifications? oracle describes in its documentation that datapump is faster than the deprecated export and that the deprecated exp function shouldn't be used anymore. currently this isn't true and we are at a big disadvantage now, since we are using datapump.

the expdp function "hangs" very long with the following logging output:

Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

our oracle version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

Edited by: user8995776 on Dec 18, 2010 8:29 AM