Database Utilities (MOSC)

MOSC Banner

After DB upgrade from 12cR1 to 19c datapump schema import very slow

in Database Utilities (MOSC) 11 commentsAnswered

We refreshed schema on routine based from PROD --> non-PROD env.

Earlier datapump import while we're on 12cR1 (12.1.0.2), it was taking ~ 8 hours.

After upgrading to 19c (19.7.0) now schema refresh via datapump job taking ~18 hours !!

Based on datapump import log, I can see tables importing generally completed in ~2 hours but things slow down drastically in Indexes creation. Indexes creation along taking ~ 15 hours !!

I don't find any addm findings/recommendation during indexes creation.

I see mostly DIRECT PATH READ event during indexes creation.

No changes to any database parameters when I upgraded from 12c --> 19c.

I/O systems are good, getting < 10 ms response times.

Tagged:

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