This discussion is archived
1 Reply Latest reply: Nov 16, 2012 8:56 AM by user296828 RSS

oracle 11g table compression feature

743319 Newbie
Currently Being Moderated
Is anybody using Oracle 11g's compression feature in production? I read a whitepaper on this and also read some forums/threads on this topic and so far I haven't read anything negative yet, that doesn't meant that there isn't anything that could have an adverse affect. I wanted to check with you guys out there to see if anyone is really using is this feature in production and see if there are any affects on the performance or any disadvantages of using this compression feature. I have tested this on one my major tablespace and I did see a big difference in the reduce size on the tablespace but I am still hesitated to put this into production. I would like to hear from you guys to see what you guys think?
  • 1. Re: oracle 11g table compression feature
    user296828 Expert
    Currently Being Moderated
    I have tested this on one my major tablespace and I did see a big difference in the reduce size on the tablespace but I am still hesitated to put this into production.
    Nothing better than testing the solution before you can put into real.

    http://www.oracle.com/technetwork/articles/oem/11g-compression-198295.html

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points