Inefficient SQL on esb_relation_xml Causes Significant Performance Impact in the ESB Database
Last updated on NOVEMBER 03, 2016
Applies to:Oracle ESB - Version 10.1.3.4.0 to 10.1.3.5
Information in this document applies to any platform.
***Checked for relevance on 07-November-2013***
As ESB table ORAESB.ESB_RELATION_XML grows in size, when ESB services are running; it is noticed that SQL operations done by the ESB application on table ORAESB.ESB_RELATION_XML cause a high amount of logical I/O's in the database and hence negatively impact database performance.
The following queries issued by the ESB application have been associated with this issue:
SELECT ID,SERVICE_GUID,OPERATION_GUID FROM ESB_RELATION_XML WHERE IS_STALE
SELECT SERVICE_GUID FROM ESB_RELATION_XML WHERE SERVICE_GUID
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