Incremental ETL Performance Issue - "Updating Data Into Rpt_reg_reports For New Reports"
(Doc ID 1916667.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Insight - Version 7.0.4 to 7.0.4 [Release 7.0.0]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)
Example:
| 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 |
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |