Database Utilities (MOSC)

MOSC Banner

impdp (via DBMS_DATAPUMP) with INCLUDE_METADATA = 0 generates x times more redo log than a complete

edited Jan 29, 2018 7:08AM in Database Utilities (MOSC) 4 commentsAnswered

Hi,

I'm currently trying to figure out why copying a schema using DBMS_DATAPUMP without INCLUDE_METADATA generates about 4,3 GB of redo while doing a data-only copy (INCLUDE_METADATA = 0) generates about 17,8 GB of redo.

In both cases the data is copied via database link from a different server.

I've already used log miner to see what's the main difference, but I've no clue what the figures are all about. The only thing I notice is the extremely high number of "INTERNAL" operations when doing a data-only copy.

Complete copy:

OperationCountSum(length(sql_redo))average
COMMIT40.033280.2317
DDL8.8285.406.588612
DELETE26.6376.335.452238
INSERT

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