This content has been marked as final. Show 2 replies
See you will need to understand what is really causing the issue .
First check the C$ and see how much time its taking . Also check if you can reduce the No of rows fetch by using Source Table Update date as filter .
Secondly check the time taken in I$ . See if you can reduce it by implementing the right indexes ,storage and check with ur DBA or analyze how u can improve its performance.
JKM is Journalizing KM which captures INSERT/UPDATE/DELETE (i.e CDC ) on the Source and some type of JKM method creates Trigger on Source.
You can visit this link -http://odiexperts.com/changed-data-capture-cdc/ & http://odiexperts.com/cdc-consistent/
Also look into the Oracle Official Documentation for all type of CDC and see what matches your requirement.