Forum Stats

  • 3,874,888 Users
  • 2,266,782 Discussions


Advanced Table Compression 11gR2

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 …



  • 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

  • Ravetd
    Ravetd Member Posts: 63

    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.

  • 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
This discussion has been closed.