Advanced Table Compression 11gR2

833525

We want to evaluate advanced compression option to compress one of our large EBS table which is over *250 GB* in size. Has anyone tried compressing tables of this size? I would like to know the benchmark timings and if any other pointers …

Thanks

Srini Chavali-Oracle

Welcome to the forums !

Pl post details of OS, database and EBS versions. Pl be aware that Advanced Compression is a separately licensed product. Pl see if these links help

http://blogs.oracle.com/stevenChan/2008/10/using_advanced_compression_with_e-business_suite.html
http://blogs.oracle.com/stevenChan/2008/11/early_benchmarks_using_advanced_compression_with_ebs.html
http://blogs.oracle.com/stevenChan/2010/05/new_whitepaper_advanced_compression_11gr1_benchmar.html

HTH
Srini

Ravetd

Hi,

We have already used BACIS COMPRESS on several big partitionned tables. The space ratio is 3, but it depends on datas because of the block compression algorithm.
For update-mostly workloads, Oracle recommends OLTP COMPRESS.

Hope this could be helpful.

Regards

damorgan

I use A/C often and with excellent results (current DB size > 200TB).

The amount of compression you can achieve depends on the data. The best way to find out the answer to your question is by testing in a lab environment.

701317

Considering using standard compression for the first time. How is this implemented? What is the performance impact of storing and retrieving and once I compress the table can I just restore the DB from export file and get back to original.
11gR2 Enterprise Edition on HP-UX 11.31
KM