Valid For
Replicat (coordinated mode)
Description
Use USEDEDICATEDCOORDINATIONTHREAD to force Replicat to maintain a dedicated coordination thread to apply barrier transactions. The thread ID of this thread is always 0.
By default, Replicat uses the thread with the lowest thread ID to apply barrier transactions, but that thread also includes work that is mapped to it explicitly. By using a dedicated thread for barrier transactions, you can get an accurate view in Oracle GoldenGate statistics of the number of barrier events and exposes the amount of work that is performed serially. Coordinated Replicat statistics are written to the report file and also can be viewed with the STATS REPLICAT command.
USEDEDICATEDCOORDINATIONTHREAD applies to the Replicat group as a whole, across all MAP statements.
Syntax
USEDEDICATEDCOORDINATIONTHREAD
Example
USEDEDICATEDCOORDINATIONTHREAD MAP u1.t1, TARGET u2.t1 SQLEXEC & (ID test2, QUERY 'delete from u2.t2 where col_val =100 ', & NOPARAMS)), THREAD(1), COORDINATED;