Difference between "COMPRESS FOR ALL OPERATIONS" and "COMPRESS FOR OLTP"?
I was looking through Oracle's OLTP Table Compression (11g onwards) documentation as wel开发者_如何学运维l as online resources to find the syntax and came across two different versions:
COMPRESS FOR ALL OPERATIONS
and
COMPRESS FOR OLTP
The documentation I looked through didn't mention any alternative syntax, so i was wondering if anyone here might know the difference.
Thank you!
COMPRESS FOR ALL OPERATIONS
and COMPRESS FOR OLTP
are just synonyms according to Vadzim.
On the OTN forums an oracle Ace says it's just a new name for the same thing.
http://forums.oracle.com/forums/thread.jspa?threadID=1042141&tstart=0
The same is stated here:
http://www.oracle-base.com/articles/11g/TableCompressionEnhancements_11gR1.php
COMPRESS
or COMPRESS FOR DIRECT_LOAD OPERATIONS
is part of the regular Oracle EE database, as stated in the PDF APC linked to.
It should be noted that Basic Table Compression is a base feature of Oracle Database 11g Enterprise Edition (EE). OLTP Table Compression is a part of the Oracle Advanced Compression option, which requires a license in addition to the Enterprise Edition.
精彩评论