Re: golden gate replication table

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/golden-gate-replication-table-tp8191p8197.html

Why does your replicat hang?
What is the wait of it?

what do you see in V$GG_APPLY_RECEIVER ? (during the hang)
Maybe there is a missing index in the target? Did you check using GG related SQL: Statement (ASH) (Document 1448324.1) ?
Did you size your sga properly? steams pool and everything.. select * from v$sgastat where pool like 'streams pool' and name='free memory'
Maybe it is because of a hanging DDL ? -> did you check this note -> How to investigate Replicat hanging on a DDL operation (Doc ID 1575915.1)