Determines whether or not Replication Agent generates commit log records at the primary database.
This parameter is available only for Oracle and only
used for Oracle RAC.
false
true – Replication Agent generates commit log records at the interval specified by pdb_commit_interval.
false – Replication Agent does not generate commit log records.
If pdb_commit_generation is set to true, Replication Agent generates commit log records only if it is in the Replicating state.
Generating commit log records lowers replication latency in Oracle RAC replication environments when cluster nodes are inactive but has no effect on replication latency for non-clustered replication environments. The pds_username must have the execute on DBMS_FLASHBACK permission granted for Replication Agent to generate commit log records.
The Replication Agent “Average number of seconds between log record checkpoints” statistic can be used to confirm that commit frequency results are in the desired range.
pdb_commit_interval configuration parameter.
