APPLY_PARALLELISM | MAX_APPLY_PARALLELISM | MIN_APPLY_PARALLELISM
Valid For
Oracle, Parallel Replicat
Description
Parallel Replicat has two forms of operation. It can run with a constant number of
applier threads or it can dynamically adjust the number of appliers based on the
transaction mix. These parameters control this behavior. You can adjust this
behavior to increase or decrease the number of apply threads and the initial number
of connections using the parameters APPLY_PARALLELISM,
MAX_APPLY_PARALLELISM, and
MIN_APPLY_PARALLELISM.
If these parameters are not set, then the default behavior of Parallel Replicat is to
use exactly four appliers to apply the changes to the target database.
APPLY_PARALLELISM controls the number of applier processes. If
APPLY_PARALLELISM is set, the number of appliers will not
dynamically increase or decrease based on transaction mix. If
APPLY_PARALLELISM is set, there can be times where the number
of concurrent transactions that can be applied by the Parallel Replicat is below the
number of applier threads, which can result in idle applier threads.
MAX_APPLY_PARALLELISM and MIN_APPLY_PARALLELISM are
used when you want to allow the Parallel Replicat process to dynamically adjust the
number of applier threads based on the transaction mix. You can set a minimum
(MIN_APPLY_PARALLELISM) and maximum
(MAX_APPLY_PARALLELISM) number of applier threads to define the
ranges in which the Replicat automatically adjusts its parallelism. The initial
number of connections will be in the middle of the two parameters.
APPLY_PARALLELISM is mutually exclusive with
MAX_APPLY_PARALLELISM and
MIN_APPLY_PARALLELISM. If
MAX_APPLY_PARALLELISM and
MIN_APPLY_PARALLELISM are used, then do not set
APPY_PARALLELSIM. If APPLY_PARALLELISM is set,
then do not use MAX_APPLY_PARALLELISM and
MIN_APPLY_PARALLELISM.
See Basic Parameters for Parallel Replicat in Using Oracle GoldenGate for Oracle Database.
Syntax
MIN_APPLY_PARALLELISM value MAX_APPLY_PARALLELISM value
Example
MIN_APPLY_PARALLELISM 2
MAX_APPLY_PARALLELISM 10
Parent topic: Oracle GoldenGate Parameters