Database Utilities (MOSC)

MOSC Banner

Slow for Data pump expdp

edited Apr 6, 2011 3:47AM in Database Utilities (MOSC) 13 commentsAnswered

Hi All,

Moving from traditional export to data pump expdp at Oracle 10.2.0.3 enviornment. Have tried to export a table with no records by expdp which require around 15 secs but it only takes 2 seconds by using traditional export dmp. Does we have any other fine tunning fixing this problem as we have many export jobs which exporting small sizing tables. Already applied << patch 5464834 >>, the durations has been improved but still not acceptable.

following is the a simple reference of expdp we use :

expdp usrttm4c/******** DIRECTORY=U_APP4C_MAPRB DUMPFILE=hos_expdp_tmp_201102.dmp LOGFILE=U_APP4C_MAPRB_LOG:Exp_hos_expdp_tmp_201102.log TABLES=TBL_MAPRB_D_BRANCH EXCLUDE=INDEX

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center