This content has been marked as final. Show 6 replies
Pl see a good example here - http://www.oraone.nl/blog/-/blogs/using-advanced-compression
This is for 11gR1, but should work in 11gR2 also
Thank for the information srini...
I can find the details of table compression only in the URL which u mentioned , can i find details of other advantages of AC like securefile deduplication,compression
Is license mandatory to implement this feature?
Edited by: user11178721 on Oct 21, 2009 3:46 AM
need more info
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
it is explained more in the provided links... thanks agian srini
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.