Oracle Scratchpad

August 5, 2015

Compression

Filed under: compression,Infrastructure,Oracle — Jonathan Lewis @ 1:06 pm BST Aug 5,2015

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.

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.

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 Optimizationthat’s just become very active with a number of articles on compression in its many forms.

6 Comments »

  1. 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 | Reply

  2. […] 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 BST Mar 15,2016 | Reply

  3. […] 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 BST Mar 15,2016 | Reply

  4. […] 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 BST Mar 15,2016 | Reply

  5. […] 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 BST Mar 15,2016 | Reply

  6. […] 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 BST Mar 15,2016 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.