CHECKPOINTSECS
Valid for
Extract and Replicat
Description
Use the CHECKPOINTSECS
parameter to control how often Extract and Replicat make their routine checkpoints.
-
Decreasing the value causes more frequent checkpoints. This reduces the amount of data that must be reprocessed if the process fails, but it could cause performance degradation because data is written to disk more frequently.
-
Increasing the value causes less frequent checkpoints. This might improve performance, but it increases the amount of data that must be reprocessed if the process fails. When using less frequent Extract checkpoints, make certain that the transaction logs remain available in case the data has to be reprocessed.
Note:
In addition to its routine checkpoints, Replicat also makes a checkpoint when it commits a transaction.
This parameter is only valid when using log-based extraction. Avoid changing CHECKPOINTSECS
unless directed to do so by Oracle GoldenGate Technical Support.
Default
10
Example
CHECKPOINTSECS 20