Update Statement of Table SNP_MAP_EXPR_REF Slows Down ODI Studio 12c Performance
Last updated on APRIL 04, 2018
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 to 184.108.40.206.6 [Release 12c]
Information in this document applies to any platform.
An update statement on the Oracle Data Integrator (ODI) repository takes a great deal of time to execute. This causes severe performance issues in ODI Studio. Developments are slowed down, and the User Interface (UI) is difficult to use due to the latency.
The SQL statement of interest is:
The SNP_MAP_EXPR_REF table contains over 700,000 records and is still growing.
The update is done frequently and takes 15 - 20 seconds.
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