Re: goldengate table replication performance issue

Posted by ErmanArslansOracleBlog on Jun 21, 2022; 8:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/goldengate-table-replication-performance-issue-tp10947p10957.html

Please define that "taking time" phrase of yours?
The optimizer cost of that SQL is 328.. 139588 rows processed and it is executed several times..
Maybe it is doing FTS?
Did you the explain plan? In the source and target? They both the same? Anything missing there?

For that hint, I mean restrict_all_ref_cons , we have some bugs and performance issues reported in Oracle Support.. you may want to check those as well .. But it seems -> after creating required indexes, on tables and foreign keys, replication performance becomes better --even in those cases..