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
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
1 2 3 4 5 6 7 |
SELECT cap.CAPTURE_NAME, cap.FIRST_SCN, cap.APPLIED_SCN, cap.REQUIRED_CHECKPOINT_SCN FROM DBA_CAPTURE cap, CHANGE_SETS cset WHERE cap.CAPTURE_NAME = cset.CAPTURE_NAME |
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 ...
Asynch CDC: Waiting For Dictionary Redo
I have come across (so far) four scenarios that show capture process "hanging" as WAITING FOR DICTIONARY REDO. 1. Wrong first_scn supplied for create_autolog_change_source: The first_scn when building the the data dictionary in the redo log via dbms_capture_adm.build does not match the first_scn when creating the change source on the downstream server. You need to supply the first_scn of the ...
Book Review: Inmon - DW 2.0. The Architecture for the next Generation of Data Warehousing
Get it from Amazon.co.uk Get it from Amazon.com First of all, this book is not written with the DW novice in mind. Some of the chapters require a thorough understanding of DW theory and concepts. Generally I found the book useful and I got some ideas that I will apply in one of my next projects. The biggest weakness of ...
CSV to Rows
I recently needed to convert a comma separated list of values in a table column to a column where each value in the list gets its own row in a table. So first of all let's create such a table. I have limited the number of comma separated values that will be created to 12. View Listing 1 To convert ...