Multiple ODI Integration Jobs Using the Same Database Sequence are Taking Longer Than Expected
(Doc ID 2487145.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On Oracle Data Integrator (ODI) using Oracle Database 184.108.40.206, multiple concurrent jobs utilize the same database sequence to specify what data they transfer from a common table, which is partitioned and pulled based on an identifier unique to each job.
While these jobs used to finish in a few minutes, they are now taking about ten times as long. Even separately at the original time, the jobs are slow. Re-executing the jobs thirty minutes later results in the expected times. There was no data volume change or additional jobs added to the schedule.
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