6.55 EOFDELAY | EOFDELAYCSECS

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

seconds: The delay, in seconds, before searching for data to process.
centiseconds: The delay, in centiseconds, before searching for data to process.

Example

EOFDELAY 3