NUMFILES

Valid for

Extract, Replicat

Description

Use NUMFILES to control the initial number of memory structures allocated to contain information about source and target tables specified in TABLE or MAP statements. NUMFILES must occur before any TABLE or MAP entries to have any effect.

To control the number of additional memory structures that are allocated dynamically once the NUMFILES value is reached, use the ALLOCFILES parameter (see "ALLOCFILES").

The default values should be sufficient for both NUMFILES and ALLOCFILES, because memory is allocated by the process as needed, system resources permitting.

Default

1000

Syntax

NUMFILES num_structures

num_structures: The number of memory structures to be allocated. Do not set NUMFILES to an arbitrarily high number, or memory will be consumed unnecessarily. Oracle GoldenGate memory supports up to two million tables.

Example

NUMFILES 4000