Last updated on MAY 12, 2017
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.99 [Release 11gR1]
Information in this document applies to any platform.
In KM and procedure steps, every SQL is executed as PreparedStatement.
It can result in a lot of additional parsing (CPU) costs (for some queries +70%) during the data load, without any added value.
According to the query log, every SQL submitted by the agent is first prepared, then executed. This step would make sense if the statement was executed repeatedly, but it is not the case.
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