Re: goldengate table replication performance issue

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

Just check by connecting to the database.. Using TOAD's explain plan maybe..
Of course you can always enable to trace to generate the detailed info about the execution plan.

But remember my previous update ->

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?