Oracle 参数 COMMIT_POINT_STRENGTH 官方解释，作用，如何配置最优化建议
本站中文解释
COMMIT_POINT_STRENGTH（提交点强度）是Oracle的一个参数，它主要用来控制数据库在执行事务之前检测闪回区快照信息（Snapshot Information）的程度。
该参数具体为一个整数值，取值范围为0到2：
其中，0 为禁用，即不检查闪回信息；1 为轻度检查（检查少量数据）；2 为完全检查（检查全部数据）。
正确设置这个参数的方法是，系统要求的安全性越高，设置的值越大，最高可设置为2，以保证数据一致性；若只要求安全性较低，则可以根据业务量自行设置一个合适的值，以最大限度改善数据库性能。
（注意：本参数会影响到事务的性能，如果设置的时候不慎，将可能会影响数据库的速度，因此一般情况下应尽量避免设置该参数）
官方英文解释
COMMIT_POINT_STRENGTH specifies a value that determines the commit point site in a distributed transaction.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
No |
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
Note:
This parameter is relevant only in distributed database systems.
The node in the transaction with the highest value for COMMIT_POINT_STRENGTH will be the commit point site.
The commit point site of a database should reflect the amount of critical shared data in the database. For example, a database on a mainframe computer typically shares more data among users than one on a personal computer. Therefore, COMMIT_POINT_STRENGTH should be set to a higher value for the mainframe computer.
The commit point site stores information about the status of transactions. Other computers in a distributed transaction require this information during Oracle’s two-phase commit, so it is desirable to have machines that are always available as commit point sites. Therefore, set COMMIT_POINT_STRENGTH to a higher value on your more available machines.
See Also:
-
Oracle Database
Concepts and Oracle Database
Administrator’s Guide for information on two-phase commit -
Your operating system-specific Oracle documentation for the default value of this parameter
