Extract process performance
784624Sep 28 2010 — edited Oct 6 2010
We are planning to Capture data from an Oracle OLTP table which has 40 Million DML's per day. The OLTP system is already heavily loaded and we want a light weight process to capture the changes.
Please can you share your experience with golden gate on a similar environment
Single extract process is it efficient enough to capture 40 Million changes per day.
If we have to have multiple extract processes what would be the impact(CPU,Memory per process)