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 220.127.116.11.0 and later
Oracle Service Bus - Version 18.104.22.168.0 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.
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