Oracle Apps JCA Adapter Executes Non-Shareable SQL Statements for Business Events
Last updated on APRIL 20, 2011
Applies to:Oracle SOA Platform - Version: 22.214.171.124.0
Oracle Service Bus - Version: 126.96.36.199.0 and later [Release: 11g and later]
Information in this document applies to any platform.
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