Valid For
Extract and Replicat
Description
Use the EOFDELAY
or EOFDELAYCSECS
parameter to control how often Extract, a data pump, or Replicat checks for new data after it has reached the end of the current data in its data source. You can reduce the system I/O overhead of these reads by increasing the value of this parameter.
Note:
Large increases can increase the latency of the target data, especially when the activity on the source database is low
This parameter is not valid when SOURCEISTABLE
is used. This parameter cannot be set to zero (0).
Default
The minimum is 1 second ; the maximum is 60 seconds (6000 centiseconds). The default is 1 second (100 centiseconds).
Syntax
EOFDELAY seconds | EOFDELAYCSECS centiseconds
Example
EOFDELAY 3