1.44 COMMIT_POINT_STRENGTH
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