My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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 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



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

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