Performance Issue in ODI Studio When Moving Between Tabs in an Interface

(Doc ID 1500722.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version to [Release 11gR1]
Information in this document applies to any platform.


ODI 11g Studio response time is slow when carrying out design activities.

Even a simple task such as clicking on mapping tab of an Integration interface displays the tab after a length of time.

Similarly, when an SQL trace is generated on the ODI Repository database schema for this operation, the resulting tkprof  file shows that a number of SQL instructions have executed thousands of times, and at the same time, returning zero records.


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 hundreds of Community platforms