Additional Parameter Options for Integrated Replicat and Parallel Replicat in Integrated Mode

You can set these parameters by using the DBOPTIONS parameter with the INTEGRATEDPARAMS option or dynamically by issuing the SEND REPLICAT command with the INTEGRATEDPARAMS option.

The default Replicat configuration should be sufficient. However, if needed, you can set the following inbound server parameters to support specific requirements.

Note:

For detailed information and usage guidance for these parameters, see the “DBMS_APPLY_ADM” section in Oracle Database PL/SQL Packages and Types Reference.

See DBOPTIONS for more information about the parameter.

• COMMIT_SERIALIZATION: Controls the order in which applied transactions are committed and has 2 modes, DEPENDENT_TRANSACTIONS and FULL. The default mode for Oracle GoldenGate is DEPENDENT_TRANSACTIONS where dependent transactions are applied in the correct order though may not necessarily be applied in source commit order. In FULL mode, the source commit order is enforced when applying transactions.

• BATCHSQL_MODE: Controls the batch execution scheduling mode including pending dependencies. A pending dependency is a dependency on another transaction that has already been scheduled, but not completely executed. The default is DEPENDENT. You can use following three modes:

  DEPENDENT

  Dependency aware scheduling without an early start. Batched transactions are scheduled when there are no pending dependencies.

  DEPENDENT_EAGER

  Dependency aware batching with early start. Batched transactions are scheduled irrespective of pending dependencies.

  SEQUENTIAL

  Sequential batching. Transactions are batched by grouping the transactions sequentially based on the original commit order.

• DISABLE_ON_ERROR: Determines whether the apply server is disabled or continues on an unresolved error. The default for Oracle GoldenGate is N (continue on errors), however, you can set the option to Y if you need to disable the apply server when an error occurs.

• EAGER_SIZE: Sets a threshold for the size of a transaction (in number of LCRs) after which Oracle GoldenGate starts applying data before the commit record is received. The default for Oracle GoldenGate is 15100.

• ENABLE_XSTREAM_TABLE_STATS: Controls whether statistics on applied transactions are recorded in the V$GOLDENGATE_TABLE_STATS view or not collected at all. The default for Oracle GoldenGate is Y (collect statistics).

• MAX_PARALLELISM: Limits the number of apply servers that can be used when the load is heavy. This number is reduced again when the workload subsides. The automatic tuning of the number of apply servers is effective only if PARALLELISM is greater than 1 and MAX_PARALLELISM is greater than PARALLELISM. If PARALLELISM is equal to MAX_PARALLELISM, the number of apply servers remains constant during the workload. The default for Oracle GoldenGate is 50.

• MAX_PGA_SIZE: Controls the amount of Program Global Area (PGA) allocation on the target database. The default value for Oracle GoldenGate is 1 GB. If this parameter is not set, then it is bounded by PGA_AGGREGATE_TARGET.

• MAX_SGA_SIZE: Controls the amount of shared memory used by the inbound server. The default for Oracle GoldenGate is INFINITE. For sizing recommendations, see Managing Server Resources.

• MESSAGE_TRACKING_FREQUENCY: Controls how often LCRs are marked for high-level LCR tracing through the apply processing. The default value is 2000000, meaning that every 2 millionth LCR is traced. A value of zero (0) disables LCR tracing.

• PARALLELISM: Sets a minimum number of apply servers that can be used under normal conditions. Setting PARALLELISM to 1 disables apply parallelism, and transactions are applied with a single apply server process. The default for Oracle GoldenGate is 4. For Oracle Standard Edition, this must be set to 1.

• PARALLELISM_INTERVAL: Sets the interval in seconds at which the current workload activity is computed. Replicat calculates the mean throughput every 5 X PARALLELISM_INTERVAL seconds. After each calculation, the apply component can increase or decrease the number of apply servers to try to improve throughput. If throughput is improved, the apply component keeps the new number of apply servers. The parallelism interval is used only if PARALLELISM is set to a value greater than one and the MAX_PARALLELISM value is greater than the PARALLELISM value. The default is 5 seconds.

• PRESERVE_ENCRYPTION: Controls whether to preserve encryption for columns encrypted using Transparent Data Encryption. The default for Oracle GoldenGate is N (do not apply the data in encrypted form).

• TRACE_LEVEL: Controls the level of tracing for the Replicat inbound server. For use only with guidance from Oracle Support. The default for Oracle GoldenGate is 0 (no tracing).

• WRITE_ALERT_LOG: Controls whether the Replicat inbound server writes messages to the Oracle alert log. The default for Oracle GoldenGate is Y (yes).