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 3.2.03.01 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.
Purpose
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!
