1.59 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 (1 second or 100 centiseconds ; the maximum is 60 seconds (60 seconds or 6000 centiseconds). It can be set to 1 (which is 1 centisecond) but should never be set to below 3.

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