Useful GoldenGate ACDR Views

Automatic Conflict Detection and Resolution is critical to any active/active and multi-master GoldenGate implementation. Below are some useful views to gather ACDR information:

DBA_APPLY_ERROR_MESSAGES

Displays information about the individual messages in all the error transactions generated by all applied processes in the database.

DBA_GG_AUTO_CDR_TABLES

Provides details about all the tables configured for Oracle GoldenGate automatic conflict detection and resolution (CDR).

DBA_GG_AUTO_CDR_COLUMNS

Provides details about all the Oracle GoldenGate automatic conflict detection and resolution (CDR) columns in the database.

DBA_GG_AUTO_CDR_COLUMN_GROUPS

Provides details about all the Oracle GoldenGate automatic conflict detection and resolution (CDR) column groups in the database.


If you are not yet taking advantage of the GoldenGate active/active feature, I highly recommend you review it and send me any questions. Making your applications highly available, fault-tolerant, and performing flawlessly can provide you with many benefits.