oracle “压缩所有操作”和“压缩 OLTP”之间的区别？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2425589/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Difference between "COMPRESS FOR ALL OPERATIONS" and "COMPRESS FOR OLTP"?
提问by tth
I was looking through Oracle's OLTP Table Compression (11g onwards) documentation as well as online resources to find the syntax and came across two different versions:
我正在浏览 Oracle 的 OLTP 表压缩（11g 以上）文档以及在线资源以查找语法并遇到两个不同的版本：
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!
谢谢！
采纳答案by DelGurth
The cynical person would be wrong.
愤世嫉俗的人是错的。
On the OTN forums an oracle Ace says it's just a new name for the same thing.
在 OTN 论坛上，oracle Ace 说这只是同一事物的新名称。
http://forums.oracle.com/forums/thread.jspa?threadID=1042141&tstart=0
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
http://www.oracle-base.com/articles/11g/TableCompressionEnhancements_11gR1.php
Just: COMPRESS or COMPRESS FOR DIRECT_LOAD OPERATIONS is part of the regular Oracle EE database, as stated in the PDF APC linked to.
只是：COMPRESS 或 COMPRESS FOR DIRECT_LOAD OPERATIONS 是常规 Oracle EE 数据库的一部分，如链接到的 PDF APC 中所述。
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.
应该注意的是，基本表压缩是 Oracle 数据库 11g 企业版 (EE) 的基本特性。OLTP 表压缩是 Oracle Advanced Compression 选件的一部分，除企业版外还需要许可证。
回答by APC
A cynical person might suggest the key difference between is that COMPRESS FOR ALL OPERATIONS is part of the regular Oracle Enterprise Edition databasewhereas COMPRESS FOR OLTP is part of the Advanced Compression Option (pdf)and so is a chargeable extra to the EE license.
愤世嫉俗的人可能会认为，两者的主要区别在于 COMPRESS FOR ALL OPERATIONS 是常规 Oracle 企业版数据库的一部分，而 COMPRESS FOR OLTP 是Advanced Compression Option (pdf) 的一部分，因此是 EE 许可的额外收费。
From a features point of view, COMPRESS FOR ALL OPERATIONS is distinguished from COMPRESS FOR DIRECT_LOAD OPERATIONS; that is, it is applied to all DML statements not just bulk inserts. The advantage of COMPRESS FOR OLTP is that (according to the white paper) it has been highly tuned to have a minimal impact on DML statements, which makes it more suitable for OLTP applications. So it is a performance enhancement rather than additional functionality.
从特性上看，COMPRESS FOR ALL OPERATIONS 与 COMPRESS FOR DIRECT_LOAD OPERATIONS 不同；也就是说，它不仅适用于批量插入，还适用于所有 DML 语句。COMPRESS FOR OLTP 的优势在于（根据白皮书）它经过高度调整，对 DML 语句的影响最小，这使其更适合 OLTP 应用程序。所以它是性能增强而不是附加功能。
