RE: Is Anyone Using Change Data Capture
- From: Peter Barnett <regdba@xxxxxxxxx>
- To: "Loughmiller, Greg" <greg.loughmiller@xxxxxxxxxxxx>, Oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Mar 2006 12:22:04 -0800 (PST)
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.
--- "Loughmiller, Greg"
<greg.loughmiller@xxxxxxxxxxxx> wrote:
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxx
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne@xxxxxxxxxxx
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
