golden gate replication table

Posted by Roshan on Apr 01, 2020; 6:55am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/golden-gate-replication-table-tp8191.html

OGG 18.0
Solaris 11
RAC 2 nodes.

Hi Erman,

I noticed every month on the first day, replicat hangs for a particular table - GPRS_HOME_CDRS. WHen I comment this table, the replicat runs fine.

I have generated the healthcheck report and noticed the sql id below being executed:

cdk1vb3mrsxp4, fg6vd7qu841pj

health01Apr2020.html
reploggt.prm
ggserr.log

I used any of the parameters below but still replicat gets hanged.

--DBOPTIONS INTEGRATEDPARAMS(PARALLELISM 4, COMMIT_SERIALIZATION FULL)
BATCHSQL BATCHESPERQUEUE 1000,BATCHTRANSOPS 100000, OPSPERBATCH 100000,OPSPERQUEUE 100000

Could you please advise.


Regards,

Roshan