Oracle Apps JCA Adapter Executes Non-Shareable SQL Statements for Business Events (Doc ID 1275481.1)

Last updated on APRIL 20, 2011

Applies to:

Oracle SOA Platform - Version: 11.1.1.3.0 and later   [Release: 11gR1 and later ]
Oracle Service Bus - Version: 11.1.1.3.0 and later    [Release: 11g and later]
Information in this document applies to any platform.

Symptoms

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.


Cause

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