Database Utilities (MOSC)

MOSC Banner

Slow datapump exports on 12.1 for schemas in one database but another almost database

edited Nov 19, 2017 4:04AM in Database Utilities (MOSC) 8 commentsAnswered

I have two very similar databases running from the same 12.1.0.1.0 oracle home on the same machine, on the same disks with the same memory allocation etc. These  databases/schemas are for different customers using the same application, so although the schemas definitions and data contained is not identical, it is very similar. (As described below, even the datapump startup is massively slower, so I don't think it's a matter of a difference in data/data definition)

Each database has about 5 schemas of approximately the same size. On database A, the datapump exports take on average of about 2 minutes. On database B, the exports take on average, about 20 minutes - even for extremely small schemas.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center