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.
Avoid changing CHECKPOINTSECS
unless you first open an Oracle service request.
Default
10 seconds
Example
CHECKPOINTSECS 20
Parent topic: Oracle GoldenGate Parameters