Oracle Apps JCA Adapter Executes Non-Shareable SQL Statements for Business Events (Doc ID 1275481.1)
Last updated on APRIL 20, 2011
Oracle SOA Platform - Version: 22.214.171.124.0 and later [Release: 11gR1 and later ] Oracle Service Bus - Version: 126.96.36.199.0 and later [Release: 11g and later] Information in this document applies to any platform.
An Oracle Application adapter in Oracle Service Bus or SOA Suite is configured for polling events from EBuisness Suite. Oracle Apps Adapter generates and execute SQL statements for polling data from E Business Suite. The problem is that the SQL statement which is used by the Oracle Apps Adapter does not use a "bind variable" in its queries. This results in huge performance impact to CPU and Memory, as the Oracle DB has to load every SQL statement into the SGA, and create a new execution plan for each SQL. This happens because instead of passing a bind variable for MSGID, it passes a STRING.
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