Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Table Compression Enhancements in Oracle Database 11g Release 1 - Save space and improve performance of OLTP systems using the enhanced table compression in 11g.



Vikram said...

Hi,

Do any of these COMPRESS options need the Advanced Compression license?

Tim... said...

Hi.

Basic compression is free. The OLTP compression is part of the Advanced Compression option. I will note this in the article.

Cheers

Tim...

Balraj Singh said...

I test this in 11.2.0.4 and found that we can still have

COMPRESS FOR DIRECT_LOAD OPERATIONS,
COMPRESS FOR ALL OPERATIONS,


Shouldn't this all be replaced by COMPRESS FOR OLTP and mentioned in the article at top ? Pls advise.


Thanks
Balraj S

Tim... said...

Hi.

You are meant to use COMPRESS FOR OLTP, but COMPRESS FOR ALL OPERATIONS is still a valid syntax, but it is deprecated, meaning it might be removed in a future release.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)