Versions Compared

Key

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

When a conflict arises, especially the "0 rows affected" conflict, it may be useful to view the opened uncommitted transactions on applyAPPLY

The can be done with the list transactions command:

...

This commands shows the Transaction ID of the SQL that is uncommitted on ApplyAPPLY. The transaction id is the hex value of the combined columns XIDUSN, XIDSLOT, XIDSQN from v$transaction on the source database. The Transaction ID is also set in columns MODULE and ACTION from V$SESSION on the target database.

...