Database Utilities (MOSC)

MOSC Banner

12c : IMPDMP performance.

edited Dec 23, 2019 9:04AM in Database Utilities (MOSC) 8 commentsAnswered

Hello,

We are  export 11gR2 database and importing into 12c database.     Export takes around 4.5 hours , while import takes around  27 hours.      Here are some of the import stats

     Completed 43228 PACKAGE_BODY objects in 10586 seconds

     Completed 63047 INDEX objects in 84578 seconds

     Completed 44080 TABLE_STATISTICS objects in 12928 seconds

     Completed 47067 DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA objects in 4886 sec                                                                                       

Couple of things to improve the performance , which I am trying is   ,       Exclude  Statistics during import and  do it separately.     

Increase PGA_Aggregrate_target  to around 30G to improve index creation performance.

Is there any other parameters that we can change to improve performance.

Thanks,

Ram

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