Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is Anyone Using Change Data Capture

RE: Is Anyone Using Change Data Capture

From: Peter Barnett <regdba_at_yahoo.com>
Date: Thu, 9 Mar 2006 12:22:04 -0800 (PST)
Message-ID: <20060309202204.44839.qmail@web31002.mail.mud.yahoo.com>


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



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
Received on Thu Mar 09 2006 - 14:22:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US