Valid For

Extract

Description

Use the FLUSHSECS or FLUSHCSECS parameters to control when Oracle GoldenGate flushes the Extract memory buffer. When sending data to remote systems, Extract buffers data to optimize network performance. The buffer is flushed to the target system when it is full or after the amount of time specified with FLUSHSECS or FLUSHCSECS. Data changes are not available to the target users until the buffer is flushed and the data is posted.

Increasing the value of FLUSHSECS or FLUSHCSECS could result in slightly more efficient use of the network, but it could increase the latency of the target data if activity on the source system is low and the buffer does not fill up. When source tables remain busy, FLUSHSECS and FLUSHCSECS have little effect.

Default

The default is 1. The maximum is 5000. FLUSHSECS can be set to 0 but FLUSHCSECS cannot be set to 0.

Syntax

FLUSHSECS seconds | FLUSHCSECS centiseconds

seconds

The delay, in seconds, before flushing the buffer.

centiseconds

The delay, in centiseconds, before flushing the buffer.

Example

FLUSHSECS 80