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


and the parfile I used for the expdp:


USERID=system/PASSWD

DUMPFILE=dpump1:tstht90_a%U.dmp,dpump2:tstht90_b%U.dmp,dpump3:tstht90_c%U.dmp

PARALLEL=3

FULL=Y

JOB_NAME=tstht90_full_expdp

COMPRESSION=ALL

FILESIZE=2GB

LOGFILE=dpump1:tstht90_full_expdp.log

REUSE_DUMPFILES=Y

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s