Property | Description |
---|---|
Parameter type | Integer |
Default value | 1 |
Modifiable | No |
Range of values | 0 to255 |
Basic | No |
COMMIT_POINT_STRENGTH
is relevant only in distributed database systems. It specifies a value that determines thecommit point sitein a distributed transaction. The node in the transaction with the highest value forCOMMIT_POINT_STRENGTH
will be the commit point site.
COMMIT_POINT_STRENGTH是一个与仅与分布式数据库系统相关的参数。它的取值决定了在分布式事务中哪一个节点作为COMMIT POINT SITE。在分布式事务中,具有最高COMMIT_POINT_STRENGTH的节点作为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.
作为commit point site节点的数据库应该分配有大量关键数据。例如,与PC机相比,位于大型机上的数据库用户通常分配更多的数据。因此,大型机上的数据库应该具有较高的COMMIT_POINT_STRENGTH值。
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, setCOMMIT_POINT_STRENGTH
to a higher value on your more available machines.
作为commit point site节点的数据库存储与分布式事务相关的信息。在2pc过程中,位于分布式事务中的其他数据库节点请求位于commit point site中的事务信息,因此作为commit point site节点的数据库必须是有效的。总之,我们需要设置具有高可用性的数据库为
COMMIT_POINT_STRENGTH节点。
在分布式事务中,Commit Point Site非常重要,它首先执行COMMIT或ROLLBACK操作的站点。Commit Point Site和其它站点不一样,从来不会进入prepared状态,所以不会存在IN-DOUBT事务,也不会因为分布式事务的失败而被阻塞。
如果用户rollback分布式事务,调度器会直接通知各个节点rollback,结束分布式事务,而不会决定commit point site。