Moving to Advanced compression

e ran some tests recently with advanced compression to see how much space it would save us and the impact it would have on performance.

The simple test we ran was:

expdp / directory=DATA_PUMP_DIR schemas=TP_INT flashback_time=systimestamp
to export the test schema out

create tablespace comptest default compress for all operations; -- to create the adv compression tablespace

impdp / remap_schema=TP_INT:COMPTEST remap_tablespace=TPCONS:COMPTEST TRANSFORM=SEGMENT_ATTRIBUTES:n

to then do the import (remapping schema/tablespace) - note the transform option which we need to strip off the default storage syntax which is nocompress and will override the tablespace setting.

The data was compressed from 60GB to 30GB (compression varied from table to table).


2 comments:

  1. Do you need license for TRANSFORM=SEGMENT_ATTRIBUTES:n
    or does it comes under basic?

    ReplyDelete
    Replies
    1. The transform option is not separately licensed,

      Delete