Incremental ETL Performance Issue - "Updating Data Into Rpt_reg_reports For New Reports"
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.
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)
|Number of cases ||Total Time taken||Time 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|
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