WARNRATE
Valid For
Replicat
Description
Use the WARNRATE
parameter to set a threshold for the number of SQL errors that can be tolerated on any target table before being reported to the process report and to the error log. The errors are reported as a warning. If your environment can tolerate a large number of these errors, increasing WARNRATE
helps to minimize the size of those files.
When setting WARNRATE
for a coordinated Replicat, take into account that the specified WARNRATE
threshold is applied to each thread in the configuration, not as an aggregate threshold for Replicat as a whole. For example, if WARNRATE 100
is specified, it is possible for each thread to return 99 errors without a warning from Replicat.
For Replicat running in an Oracle environment, this parameter is valid for nonintegrated mode only.
Default
100 errors
Syntax
WARNRATE number_of_errors
Example
WARNRATE 1000
Parent topic: Oracle GoldenGate Parameters