My Oracle Support Banner

Multiple ODI Integration Jobs Using the Same Database Sequence are Taking Longer Than Expected (Doc ID 2487145.1)

Last updated on MAY 01, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

On Oracle Data Integrator (ODI) using Oracle Database 12.1.0.2, 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.

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!

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