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.
There’s a significant warning about basic compression in this comment on one of my notes about a bug with index compression and row dependencies.
Comment by Jonathan Lewis — May 21, 2014 @ 8:41 pm BST May 21,2014 |
[…] There is a catalogue of all five items in this series (and a few others) at this URL […]
Pingback by Compression in Oracle – Part 1: Basic Table Compression – All Things Oracle — March 15, 2016 @ 10:10 pm GMT Mar 15,2016 |
[…] There is a catalogue of all five items in this series (and a few others) at this URL […]
Pingback by Compression in Oracle – Part 2: Read-Only Data – All Things Oracle — March 15, 2016 @ 10:11 pm GMT Mar 15,2016 |
[…] There is a catalogue of all five items in this series (and a few others) at this URL […]
Pingback by Compression in Oracle – Part 3: OLTP Compression – All Things Oracle — March 15, 2016 @ 10:11 pm GMT Mar 15,2016 |
[…] There is a catalogue of all five items in this series (and a few others) at this URL […]
Pingback by Compression in Oracle – part 4: Basic Index Compression – All Things Oracle — March 15, 2016 @ 10:12 pm GMT Mar 15,2016 |
[…] There is a catalogue of all five items in this series (and a few others) at this URL […]
Pingback by Compression in Oracle – part 5: Costs of Index Compression – All Things Oracle — March 15, 2016 @ 10:16 pm GMT Mar 15,2016 |
learn more
Compression | Oracle Scratchpad
Trackback by discuss — September 21, 2019 @ 1:51 pm BST Sep 21,2019 |