CDC & Streams Performance Test

Uli Bethke Change Data Capture

Scenarios Objective of the Streams Performance Test was to identify risks and bottlenecks for CDC and Streams. The following items were of particular interest to us: Identify bottlenecks for batch jobs with a low commit frequency, i.e. transactions that modify large numbers of records without committing frequently. We needed to know this because we have low commit frequency batch jobs ...

Asynch CDC: Delete old archived redo logs

Uli Bethke Oracle

The following steps need to be taken to be able to delete archived redo logs that are no longer required by the CDC capture process: 1. Determine the new first_scn for your capture process

As per Oracle documentation: This query "determines a new first_scn value that is greater than the original first_scn value and less than or equal to ...