Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Advanced Table Compression 11gR2

833525
Member Posts: 1
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
Thanks
Answers
-
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 -
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 -
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. -
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
This discussion has been closed.