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...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired