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
Example
NUMFILES 50
Parent topic: Oracle GoldenGate Parameters