My Oracle Support Banner

OBIA: DAC 10.1.3.4.1: Change Capture Task Taking Long Time to Remove Duplicate Row IDs (Doc ID 1381674.1)

Last updated on DECEMBER 13, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] to 7.9.7 [AA 2100] [Release V7]
Information in this document applies to any platform.

Symptoms

You have Oracle Business Intelligence Applications OBIA) 7.9.6.3  with a source system of Siebel 8.1.1 and a target database of Oracle 11g.  You are using the DAC process to perform an incremental update from CRM to your data warehouse. Your Full ETL process ran in 22 hours. Your incremental loads were also completing in less than 8 hours. But recently, the incremental ETL process is taking 19 hours.

The issue is happening for S_ORDER_ITEM table.

It appears that the bulk of the time got spent in removing some duplicates.
YYYY-MM-DD HH:MI:SS - Executing removing rowid duplicates.
YYYY-MM-DD HH:MI:SS - Executed successfully removing rowid duplicates.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.