Performance Issue in ODI 11.1.1.6.x Studio when Moving Between Tabs in an Interface
(Doc ID 1500722.1)
Last updated on MAY 19, 2021
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
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 |
Cause |
Solution |
References |