NUMFILES

Valid For

Extract and Replicat

Description

Use the NUMFILES parameter to control the initial number of memory structures that are allocated to contain information about tables specified in TABLE or MAP statements. NUMFILES must occur before any TABLE or MAP entries, and before the SOURCEDEFS or TARGETDEFS parameter, to have any effect.

When setting NUMFILES for a coordinated Replicat, take into account that the specified value is applied to each thread in the configuration, not as an aggregate threshold for Replicat as a whole. For example, if NUMFILES 500 is specified, it is possible for each thread to have 499 initial memory structures without any warning or error from Replicat.

To control the number of additional memory structures that are allocated dynamically once the NUMFILES value is reached, use the ALLOCFILES parameter. See "ALLOCFILES" for more information. The default values should be sufficient for both NUMFILES and ALLOCFILES, because memory is allocated by the process as needed, system resources permitting. The minimum is 1 and the maximum is 20000. While the maximum values is 20000, Oracle GoldenGate can support up to 2 million tables in a single Replicat or Extract.

Default

1000

Syntax

NUMFILES number

number

The initial number of memory structures to be allocated. Do not set NUMFILES to an arbitrarily high number, or memory will be consumed unnecessarily.

Example

NUMFILES 50