LOGGING of Conflict Resolution (SharePlex 8.6.6):
To log details on how SharePlex resolves conflict resolution, install or patch to SharePlex 8.6.6 which has a new parameter called SP_OPO_LOG_CONFLICT that controls logging and information is stored in shareplex_conf_log table.
SP_OPO_LOG_CONFLICT
This parameter enables the logging of information about successful conflict resolution procedures to the SHAREPLEX_CONF_LOG table. This feature applies only to the prepared routines that are provided by .
This parameter offers two active settings:
A setting of 1 enables the logging of conflict resolution to the SHAREPLEX_CONF_LOG table.
A setting of 2 enables the logging and also directs Post to query the target database to get the current timestamp of the target row. Note: A setting of 2 may affect the performance of Post as a result of making the query. It populates EXISTING_TIMESTAMP column in shareplex_conf_log table.
Default: 0 (Disabled)
Range of valid values: 0, 1, or 2
Takes effect: when Post is restarted
Here is the describe on shareplex_conf_log table.
SQL> desc shareplex_conf_log
Name Null? Type
----------------------------------------- -------- ----------------------------
CONFLICT_NO NOT NULL NUMBER
CONFLICT_TIME TIMESTAMP(6)
SRC_HOST VARCHAR2(32)
CURR_HOST VARCHAR2(32)
TRUSTED_HOST VARCHAR2(32)
SRC_ORA_SID VARCHAR2(32)
SOURCE_ROWID VARCHAR2(20)
TARGET_ROWID VARCHAR2(20)
CONFLICT_TABLE VARCHAR2(100)
CONFLICT_TYPE VARCHAR2(1)
CONFLICT_RESOLVED NOT NULL VARCHAR2(1)
ORACLE_ERR VARCHAR2(10)
TIMESTAMP_COLUMN VARCHAR2(50)
INCOMING_TIMESTAMP TIMESTAMP(6)
EXISTING_TIMESTAMP TIMESTAMP(6)
PRIMARY_KEYS VARCHAR2(4000)
MESSAGE VARCHAR2(400)
SQL_STATEMENT LONG
CONFLICT_CHECKED VARCHAR2(1)
SEQNO NUMBER
OFFSET NUMBER
SCN NUMBER
USERID NUMBER
