Performance Issue in ODI 11.1.1.6.x Studio When Moving Between Tabs in an Interface (Doc ID 1500722.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

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.

Cause

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