Compression in Oracle, by Jonathan Lewis

From: Mladen Gogala <>
Date: Sun, 10 Feb 2013 04:27:16 +0000 (UTC)
Message-ID: <>

I just wanted to share this with the group

This is an excellent article, with good technical information. The only remark that I have is the remark that Oracle doesn't do compression but deduplication. The problem is, of course, in the fact that compression really is deduplication. If one checks the most popular family of compression algorithms invented by Lempel, Ziv and Welch (that's where "LZW" comes from), one will see that it's all about deduplication. Essentially, those guys are building dictionary of things and, when encounter an existing item, mark it with a pointer. Deduplication and compression are, essentially, one and the same. The description and the fact that Oracle pins the block during the reconstruction are excellent. I really enjoyed reading the article.

Mladen Gogala
The Oracle Whisperer
Received on Sun Feb 10 2013 - 05:27:16 CET

Original text of this message