CDC performance - synchronous vs. asynchronous hotlog

  • From: Aaron Leonard <aachleon@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 2 Jun 2010 13:47:41 -0500

All, I'm looking for some performance advice on Change Data Capture (CDC)
modes.  I'm new to CDC and have been tasked with setting it up in an
environment ( EE on OEL) where the change table will reside in the
same database (and same schema) as the source table.  This leaves us with
the option of 2 CDC modes, Synchronous and 'Asynchronous Hotlog'.

I've read general statements saying that using 'Asynchronous Hotlog'
provides some performance gains over Synchronous.  However, given that Async
Hotlog requires additional logging and the use of streams to/from the same
database where Synchronous does not, I question whether or not there is
there a significant difference.  Thoughts?

Please excuse my ignorance on the subject.  Any insight is appreciated!


Other related posts: