Re: golden gate replication table

Posted by ErmanArslansOracleBlog on Apr 04, 2020; 8:52am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/golden-gate-replication-table-tp8191p8201.html

Using swap is not a problem , but if the OS is doing Swap I/O then it is a problem..
The important thing to check is the number of swap in and out operations.

As for the indexes, what you need to is;

1) Stop Replicat.
2) Created an index to the problematic the table.
3) Start Replicat.

Then, Replicat could proceed the replication.

Ref: Integrated Replicat Hangs with State 'Waiting for memory' without Indexes at Target Database (Doc ID 2554761.1)
Additional Ref: GoldenGate Integrated Capture and Integrated Replicat Healthcheck Script (Doc ID 1448324.1)