Make a difference to your bottom line with BI

Uli Bethke Business Intelligence

Get it from Amazon.com Get it from Amazon.co.uk In the first two chapters the authors develop their core argument. BI projects are only successful when they have a positive impact on the bottom line of an organisation. BI so the central and simple theme of the authors, needs to give an organisation competitive advantage by either increasing its profits or ...

OWB Best Practice Part 1: Logically organise your DW project with Collections

Uli Bethke Best Practice, Oracle Warehouse Builder

Once you have gone beyond the implementation of more than one data mart for your Enterprise Data Warehouse project in Oracle Warehouse Builder, it becomes harder and harder to find a particular object for editing amongst the hundreds or thousands of objects. OWB Collections come to the rescue. They allow you to logically organise your project into virtual folders by ...

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 ...

Asynch CDC: Waiting For Dictionary Redo

Uli Bethke Oracle

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 ...