Re: LOB compression

From: Mark D Powell <>
Date: Mon, 1 Aug 2011 08:26:46 -0700 (PDT)
Message-ID: <>

On Jul 27, 11:50 pm, Mladen Gogala <> wrote:
> On Thu, 28 Jul 2011 01:10:14 +0000, Mladen Gogala wrote:
> > I know that I need advanced compression option if I compress table for
> > all operations. Do I need advanced compression license if I compress
> > just LOB columns? The problem is licensing, I can't exceed the licenses
> > allotted and the company didn't purchase the advanced compression
> > option. DB version is:
> OK, I found it. The news is not good:
> I quote:
> About Deduplication
> SecureFiles Intelligent Deduplication, available with the Oracle Advanced
> Compression Option, enables Oracle Database to automatically detect
> duplicate LOB data within a LOB column or partition, and conserve space
> by storing only one copy of the data.
> Note that you must have a license for the Oracle Advanced Compression
> Option before implementing SecureFiles Intelligent Deduplication. See
> Oracle Database Licensing Information for more information.
> Same applies to compression. Bummer.
> --

Unfortunately, a lot of the better new features are all extra-cost options. It can be pretty difficult to keep track of what is OK to use since so much of the extra-charge items come included with the database like the AWR. It is there and Oracle automatically collects data but if you want to look at it you need the EM Diagnostic and/or Performance Pack options.

HTH -- Mark D Powell -- Received on Mon Aug 01 2011 - 10:26:46 CDT

Original text of this message