Golden Gate replication for a huge table
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 18 Oct 2016 15:32:41 -0700
Message-ID: <CAHDOOG6m1=e0YbNbKAZ-fZ2uU+JNnoJZQiWPA6ayaGrtoiMsZw_at_mail.gmail.com>
Hi
We are in the initial phases of evaluating Golden Gate. One of our developers has a concern.
She has a table that has 40 million rows that would be replicated to the target and after the initial load, the data volume changes on a daily basis would be in the 1000's (basically not in the range of millions of records but in 1000's or 10000's during year end processing for example). Her concern was will Golden Gate replication be able to handle this. From my understanding this should not be a problem. Wanted to get inputs from folks who have done this already (since my experience at this point of time is only working with small tables and reading documentation).
Date: Tue, 18 Oct 2016 15:32:41 -0700
Message-ID: <CAHDOOG6m1=e0YbNbKAZ-fZ2uU+JNnoJZQiWPA6ayaGrtoiMsZw_at_mail.gmail.com>
Hi
We are in the initial phases of evaluating Golden Gate. One of our developers has a concern.
She has a table that has 40 million rows that would be replicated to the target and after the initial load, the data volume changes on a daily basis would be in the 1000's (basically not in the range of millions of records but in 1000's or 10000's during year end processing for example). Her concern was will Golden Gate replication be able to handle this. From my understanding this should not be a problem. Wanted to get inputs from folks who have done this already (since my experience at this point of time is only working with small tables and reading documentation).
Thanks for your time.
Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 19 2016 - 00:32:41 CEST