Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

EDQ Performance Issue

User_TA74OJan 22 2021

Please advice , what are all the actions I need to do to improve the performance of EDQ jobs. I have millions of data, somedays it takes 30m to process 300k-400k records, but somedays it takes 7-8 hours to process 800k records. What are the possible steps that can be taken:
The steps that we have already taken to improve the performance are given below, but nothing worked, the duration is still the same.
Replaced the existing views with materialised views
Deselected the 'Staged Data' option during job configuration to directly stream the data
Tried to replace the existing SQL query with a new staging table
Please advise if there are any other ways for the performance tuning.
Thanks,
Anamika

Comments
Post Details
Added on Jan 22 2021
4 comments
172 views