This content has been marked as final. Show 2 replies
Hi,1 person found this helpful
If you have sufficient privileges, you could try to use LKM Oracle to Oracle (DBLINK). It should run in about 5mins.
See you will need to understand what is really causing the issue .1 person found this helpful
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.