Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

All keywords are case-insensitive.

...

By default, the number of rows processed/minute represents APPLY performance; use LIST STATS TOTAL MINE to see mine statistics.

List opened uncommitted transactions on apply. The Transaction ID is the hex value of the combined columns XIDUSN, XIDSLOT, XIDSQN from v$transaction on the source database. 

Use APPLY COMMIT TRANSACTION to force commit of the specified transactions on apply.

The transaction list may also include internal non committed transaction not related to the replication.

APPLY

APPLY COMMIT TRANSACTION. Force  Force commit of the specified transaction on apply. Use LIST TRANSACTIONS first to see what transactions are currenlty pending on apply.

...

The DEFAULT conflict handler will not be applied to existing prepared (replicated) tables. The DEFAULT conflict handler will only be applied to tables that are prepared after the DEFAULT conflict handler is set. To change the conflict handler for existing prepared tables, each table has to be individually set using FOR TABLE conflict handler.

SHOW_CONFLICT_HANDLERS

Shows current setting of conflict handlers for given table (schema.name refers to table at mine).

...