FUNCTIONSTACKSIZE
Valid For
Extract and Replicat
Description
Use the FUNCTIONSTACKSIZE
parameter to control the size of the memory stack that is used for processing Oracle GoldenGate column-conversion functions. The memory stack holds arguments supplied to and from an Oracle GoldenGate function. You should not need to use this parameter unless Oracle GoldenGate returns a message indicating that the size of the stack should be increased. The message is similar to:
Not enough stack space. Specify FUNCTIONSTACKSIZE greater than {0,number,0}
This could happen when you are using a very large number of functions or arguments.
The default without FUNCTIONSTACKSIZE
is 200 arguments, which optimizes the performance of Oracle GoldenGate and its usage of system memory. Increasing this parameter can adversely affect performance and the use of system memory.
When setting FUNCTIONSTACKSIZE
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 FUNCTIONSTACKSIZE 400
is specified, it is possible for each thread to have 399 arguments without any warning or error from Replicat.
FUNCTIONSTACKSIZE
must appear in the parameter file before any parameters that include functions are listed. FUNCTIONSTACKSIZE
is a global parameter. It affects all clauses in a parameter file.
Default
200 arguments
Syntax
FUNCTIONSTACKSIZE number
Example
FUNCTIONSTACKSIZE 300