MAXETCHECKPOINTSECS
Valid for
Replicat
Description
Use MAXETCHECKPOINTSECS to specify the maximum amount of time that Replicat waits before writing a checkpoint. A checkpoint saves the state of processing and is used for recovery in the event of an application failure. The length of time between checkpoints defines the amount of data that may need to be reprocessed from the data source in the event of an application failure.
Reducing MAXETCHECKPOINTSECS prevents Replicat from having to read too far back into the data source if a failure occurs. However, since checkpoints commit data to disk, it could cause performance degradation because data is written to disk more frequently.
Increasing MAXETCHECKPOINTSECS reduces the number of checkpoints, which might improve performance, but it requires Replicat to read further back into the data source in the event of a failure. To make that data available, prevent the logs containing it from being removed or overwritten.
Avoid using MAXETCHECKPOINTSECS unless directed to do so by Oracle GoldenGate Technical Support.
Default
10