My Oracle Support Banner

ODI J2EE and Standalone/Collocated Agents are Slower than "Local (No Agent)" (Doc ID 2776078.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.4.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

In Oracle Data Integrator (ODI) 12c, execution time of one and the same mapping is significantly longer if using the Standalone / Collocated or J2EE Agent compared to executing with "Local (No Agent)".
All agents are running on one and the same server, yet the performance achieved is very different.


For example:

Standalone Collocated or J2EE Agent took 787 seconds to process  3252571 records:

 

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.