Table & Index Compression on 11g

[Former Member]

Hi,

We are planning to upgrade oracle ( RAC ) from 10.2.0.4 to 11.2 and planning to turn on table and index compression. I would like to learn the pros & cons of turning compression on in a 6TB database. Any performance issues after table/index compression .

Thanks

Prince Jose

[Former Member]

Hey Prince,

Just check out the below thread if it can give you some idea for the same...