My Oracle Support Banner

Poor Performance when Refreshing ODI Operator 12c (Doc ID 2479408.1)

Last updated on JULY 10, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.3.221018 [Release 12c]
Information in this document applies to any platform.

Symptoms

Using Oracle Data Integrator (ODI) Studio version 12.2.1.3.0, in a Repository with a large number of Scenarios, ie. 1000 or more, "refresh" in "Operator" tab takes a significant amount of time if the "Load Plans and Scenarios" is opened.

With "Load Plans and Scenarios" closed, the refresh is much faster.

The refresh takes longer over time with each refresh. There was no performance degradation noticed in ODI 11g, and this appears to be specific to ODI 12c.

To reproduce the behavior:

  1. Have an ODI 12c Repository with a good number of Scenarios.
  2. Go to ODI Studio > Operator tab.
  3. Hit "Refresh", and notice it is fast.
  4. Open the "Load Plan and Scenarios" view.
  5. Hit "Refresh" again, and notice it takes a significant amount of time.
  6. Hit "Refresh" again, and notice it takes longer than previous time.

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!


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