Database Tuning (MOSC)

MOSC Banner

Drop schema & Datapump import extremely slow due to massive amount of LOBs: tunable ?

edited Jan 28, 2020 4:01AM in Database Tuning (MOSC) 6 commentsAnswered

Hello,

On a bunch of databases (either 12c or 18c) running on ASM, where we

regularly copy data (schema datapump imports), the jobs take hours and hours:

o first we completely drop the schema, it takes 3 hours,

o then do the DP import (takes about the same duration).

Schema is only 380GB big but DBA_SEGMENTS shows 48% of this room

taken by type LOBSEGMENT...

Anybody has an idea whether we could improve the time it takes to

complete both ops: drop schema, and import ?

Addendum: just noticed that 92% (thus 171GB of total) of these LOBs are

concentrated on a single tablespace (these are images)... No magics existing

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