Incremental ETL Performance Issue - "Updating Data Into Rpt_reg_reports For New Reports" (Doc ID 1916667.1)

Last updated on AUGUST 12, 2014

Applies to:

Oracle Argus Insight - Version 7.0.4 and later
Information in this document applies to any platform.

Symptoms

During incremental ETL, 1 particular following update on RPT_REG_REPORTS was taking very long time.

Updating data into rpt_reg_reports for new reports(former_submission_date)


 eg.,

Number of cases
Total Time takenTime taken by REG_REPORT thread
3K 1.8 Hours 1 hour 3 minutes
5K 2.59 Hours 1 Hour 30 minutes
20K 4.39 Hours 1 Hour 25 minutes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms