impdp (via DBMS_DATAPUMP) with INCLUDE_METADATA = 0 generates x times more redo log than a complete
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:
Operation | Count | Sum(length(sql_redo)) | average |
COMMIT | 40.033 | 280.231 | 7 |
DDL | 8.828 | 5.406.588 | 612 |
DELETE | 26.637 | 6.335.452 | 238 |
INSERT |