My Oracle Support Banner

Known Performance Issues with ODI 12.2.1.4 (Doc ID 2767473.1)

Last updated on JANUARY 30, 2025

Applies to:

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

Purpose

 Performance issues are difficult to diagnose and fix, and are often not just one solution. With the distributed design and use of Oracle Data Integrator (ODI), performance bottlenecks may be located in several different areas.

 The goal for this article is to document solutions related to performance that occur only with ODI 12.2.1.4.x releases.

Questions and Answers

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
Purpose
Questions and Answers
 I. Recursive Scenarios
 Symptoms
 Solution
 Explanation
 II. Costly connections to the database
 Symptoms
 Solution
 Explanation:
 Note
 III. Having several variables defined in a load plan, execution time is longer than normal/expected
 Symptoms
 Solutions
 Explanation
 IV. After applying ODI BP 12.2.1.4.230306 (Patch 35151900), load plan executions take a long time
 Symptoms
 Solution
 Explanation
 V. PS Gen Old space is not getting released 
 Symptoms
 Solution
 Explanation
  
  VI. ODI Sessions in WAITING and/or QUEUED status and not going down
 Symptoms
 Solution
 Explanation
  
  VII. Out of Memory Errors (OOME)
References


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