ODI Agent Session Status Query Impacts Database Performance Due To Missing Indexes In ODI 11g
Last updated on MARCH 08, 2017
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 to 22.214.171.124.99 [Release 11gR1]
Information in this document applies to any platform.
After observing poor performance when executing ODI 11g Scenarios on an Agent we have performed some auditing of the SQL instructions executed at runtime.
As a result we have identified the following SQL instruction which appears
- to be executed very frequently
- and indicate the performing of full table scans
resulting in inefficient processing and poor performance.
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