Listing of the conflict with the LIST CONFLICT command
...
Viewing all the conflicts
It is also possible to obtain the conflict information directly from the Dbvisit Replicate repository. Logon to the apply (target database) as the Dbvisit Replicate schema owner (dbvrep) and query table:
| Panel | ||
|---|---|---|
| ||
DBRSAPPLY_CONFLICT_LOG |
...
The column SQL_TEXT contains the actual SQL statement that is run against the target database and includes the bind variables.
LIST TRANSACTIONS
When viewing the conflicts, it may also be useful to view the opened uncommitted transactions on apply. This commands shows the Transaction ID of the SQL that is uncommitted on Apply. The transaction id is the hex value of the combined columns XIDUSN, XIDSLOT, XIDSQN from v$transaction on the target database. The Transaction ID is also set in columns MODULE and ACTION from V$SESSION on the target database.
The transaction list may also include internal non committed transaction not related to the replication. Please see http://support.dbvisit.com/entries/24825508-Committing-uncommitted-transactions for an example of how to use this command.