This content has been marked as final. Show 6 replies
Pl see if these links help
MOS Doc 882712.1 - 11g New feature:All About Advanced Table Compression(Overview,Use,Examples,Restrictions)
MOS Doc 785787.1 - 11g new features:Advanced Compression overview and advantages
Yes a license is required to use the features of Advanced Compression.
Among these are:
COMPRESS FOR OLTP (formerly COMPRESS FOR ALL OPERATIONS)
Compression with Data Pump
Compression with RMAN
Is it worth it? Yes yes and yes!
Spend you money on disk drives and it doesn't go very far. Spend it on compression and compress everything for a very long time.