Comparing exp with expdp + compression=all

What a difference between EXP and EXPDP with compression as seen below:

Just a quick note on the difference between running old school EXP and the somewhat newer EXPDP with COMPRESSION=ALL turned on…. if using COMPRESSION=ALL, it’s only available in 11g EE and you must pay the licensing fee for Advanced Compression to use “ALL” with the COMPRESSION parameter.

1st, I run the exp on a single mount point with the max recordlength=65535 and direct=y… this exp ran for 71 minutes and consumed roughly 45GB:

-rw-r–r– 1 oracle oinstall 45556327575 Oct 30 11:48 full_exp.dmp

The 2nd run was with expdp over 3 mount points and compression=all… it ran for 41 minutes and consumed roughly 8+GB:

-rw-r—– 1 oracle asmadmin 2147483648 Oct 30 13:54 tstht90_a01.dmp

-rw-r—– 1 oracle asmadmin 2147483648 Oct 30 13:54 tstht90_a02.dmp

-rw-r—– 1 oracle asmadmin 2147483648 Oct 30 13:55 tstht90_b01.dmp

-rw-r—– 1 oracle asmadmin 1443262464 Oct 30 14:08 tstht90_b02.dmp

-rw-r—– 1 oracle asmadminĀ  516943872 Oct 30 14:08 tstht90_c01.dmp

-rw-r—– 1 oracle asmadmin 1042018304 Oct 30 14:08 tstht90_c02.dmp

Continue reading