Inefficient SQL on esb_relation_xml Causes Significant Performance Impact in the ESB Database (Doc ID 1352321.1)

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***

Symptoms

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

 

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