Performance Issue in ODI 220.127.116.11.x Studio When Moving Between Tabs in an Interface
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 to 22.214.171.124.3 [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
Million Knowledge Articles and hundreds of Community platforms