Forum Stats

  • 3,875,555 Users
  • 2,266,945 Discussions
  • 7,912,249 Comments

Discussions

Advanced Table Compression 11gR2

833525
833525 Member Posts: 1
edited Apr 5, 2011 2:19PM in Advanced Compression
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

Answers

  • Srini Chavali-Oracle
    Srini Chavali-Oracle Member Posts: 29,596 Employee
    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
    Ravetd Member Posts: 63
    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
    damorgan Member Posts: 14,464 Bronze Crown
    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
    701317 Member Posts: 2
    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.