Incremental ETL Performance Issue - "Updating Data Into Rpt_reg_reports For New Reports"
(Doc ID 1916667.1)
Last updated on MARCH 26, 2019
Applies to:Oracle Argus Insight - Version 7.0.4 to 7.0.4 [Release 7.0.0]
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|
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