Re: Is Anyone Using Change Data Capture
- From: "Malcolm Arnold" <malcolmarnold@xxxxxxxxx>
- To: regdba@xxxxxxxxx
- Date: Fri, 10 Mar 2006 16:45:31 +0000
Hi Pete,
Looks like you probably already know this, but in 9i CDC uses
row-level triggers. In 10g CDC has an asynchronous option which uses
Streams to get changes from the redo log with less impact on the
source system.
You might want to check out: http://www.nyoug.org/lisigcdc.ppt
We're on 9iR2 here, so we were considering creating our own CDC stuff
using Streams (new in 9iR2) but that's been kiboshed due to complexity
and maintenance concerns. Streams on 9iR2 has also got a lot of bad
press.
We'll probably go with row-level triggers and take the hit on the
source system, but this hasn't been fully decided yet.
Cheers,
Malcolm.
On 09/03/06, Peter Barnett <regdba@xxxxxxxxx> wrote:
> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
