This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,140 Users
  • 2,269,775 Discussions
  • 7,916,823 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 Oracle ACE Director Planet EarthMember 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.