My Oracle Support Banner

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

Last updated on MARCH 25, 2019

Applies to:

Oracle SOA Suite - Version 11.1.1.3.0 and later
Oracle Service Bus - Version 11.1.1.3.0 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.