My Oracle Support Banner

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

Last updated on MAY 13, 2021

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 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:

 

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!


In this Document
Symptoms
Changes
Cause
Solution


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