Compression

Originally published Jan 2013

Red Gate have asked me to write a few articles for their Oracle site, so I’ve sent them a short series on “traditional” compression in Oracle – which means I won’t be mentioning Exadata hybrid columnar compression (HCC a.k.a. EHCC). There will be five articles, published at the rate of one per week starting Tuesday (15th Jan). I’ll be supplying links for them as they are published.

• Basic table compression
• Read-only data
• OLTP compression
• Basic index compression
• Costs of Index compression

Updated Aug 2015

Since I’ve got a little catalogue on compression started, I decided to add some items from my blog to the list, starting with a six-part series on HCC and compression units that I wrote (mostly) in the summer of 2012.

• Compression Units part 1
• Compression Units part 2
• Compression Units part 3
• Compression Units part 4
• Compression Units part 5
• Compression Units part 6
• Notes on advanced index compression

There are a few other items on my blog that I’ll add to this list eventually.

Updated Feb 2016

There’s a section on the official Oracle blog site – Database Storage Optimization – that’s just become very active with a number of articles on compression in its many forms.