Performance Issues in ODI Studio 11g (prior to 11.1.1.7) When the Repositories are Installed on Different, Remote Machines (Doc ID 1506078.1)

Last updated on OCTOBER 07, 2019

Applies to:

Symptoms

When the Oracle Data Integrator graphical user interface (ODI Studio) 11g is running on a machine which differs from the one that supports the Repositories, latencies might be observed in navigation operations, such as:

• Accessing Designer.
      
• Using the scroll-bars to navigate in Designer (for example, scroll in the list of Integration Interfaces in a Project > Folder).
        
  
• Opening an Integration Interface.
    
• Re-sizing the Integration Interface window in Designer.
          
• Accessing the Integration Interface "Mappings" or "Quick Edit" tab.
           
• Using the scroll-bars to navigate in the Integration Interface "Mappings" tab (use the scroll-bar right to the source Datastores..., use the scroll-bar right to the mappings..., re-size the source-Datastores window..., etc).
            
• In the Integration Interface "Mappings"tab, creating a Filter or Join on source Datastore columns.
      
  
• Accessing the "Expression Editor" on a mapping, join or filter from the "Mappings" tab of an Integration Interface.
         
  
• The Smart Export / Smart Import operations are very slow.
  

Cause

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