My Oracle Support Banner

Best Approaches for Performance Optimization Strategies for ODI Scenario Execution (Doc ID 423726.1)

Last updated on JUNE 15, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Data Integration Platform Cloud Classic - Version 17.3.5 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.


Solving data integration problems with Oracle Data Integrator (ODI) may raise questions about how to best achieve performance and scalability.

The fact that Oracle Data Integrator (ODI) Scenario execution is usually very fast is largely due to its E-LT architecture which makes use of native DBMS SQL and native DBMS utilities such as bulk loaders, unloaders and complex set-based transformations. However, despite the use of such native features some performance issues may be encountered.

This document therefore discusses performance and scalability questions and describes optimization solutions.

Troubleshooting Steps

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
Troubleshooting Steps
 Optimizing Mappings and Integration Interfaces.
 1. Reduce the data movement between servers.
 2. Accelerate the data movement by selecting the best loading strategies.
 3. Perform large joins optimally and locate them correctly.
 4. Strategies for Integrating Data.
 5. Strategies for Checking Integrity.
 Run-time optimization.
 1. Locate the Agents appropriately.
 2. Use Load Balancing.
 3. Deploy ODI Java EE Agents in Oracle WebLogic Server.
 4. Design High Availability deployment for starting with ODI 11g.
 5. Setup the execution Log Level.
 Handle performance issues.
 1. Complex SQL code processing row by row data.
 2. Incompatibilities between the JVM version and the JDBC driver version.

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