| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is Anyone Using Change Data Capture
Thanks, Oracle claims a 10 percent increase in
throughput. Sounds like they might be a bit low.
We are looking at both 10g and 9i. 10g does seem to be less intrusive - at least on paper.
> Pete,
>
> We are using it on a 9i database. It's very
> intrusive, and can add some
> significant overhead. Currently, the purge activity
> of CDC is causing
> great grief for some oracle streams activity on that
> database. Once the
> issue had been identified, it has become manageable.
> But not ideal.. I
> (in architecture) preferred not to use it, and use
> something
> non-intrusive to get the "data deltas". We looked at
> Data Mirror and
> GoldenGate. They both seem pretty good... I think
> the choice between the
> two depends on your requirements and data latency...
>
>
>
> Our understanding is that the 10g version of CDC is
> a lot cleaner.
>
>
> greg
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Peter Barnett
> Sent: Thursday, March 09, 2006 10:06 AM
> To: Oracle-l
> Subject: Is Anyone Using Change Data Capture
>
> The subject pretty much says it all. We are looking
> for a way to maintain changes to the database for
> loading downstream systems. One option is manual
> scripts, another is CDC? Looking for +/- of CDC.
>
> Thanks,
>
>
>
> Pete Barnett
> Lead Database Administrator
> The Regence Group
> pnbarne_at_regence.com
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 09 2006 - 14:22:04 CST
 |
 |