My Oracle Support Banner

Large Number of Invalid Queries on S_RR_TABLE With SearchSpec Based on Business Component Name Cause Small Performance Impact (Doc ID 2860566.1)

Last updated on MAY 19, 2022

Applies to:

Siebel CRM - Version 21.8 and later
Information in this document applies to any platform.


Invalid queries on S_RR_TABLE are observed in log files of any object manager.

They do not cause errors, but are seen as a waste of resources that can cause slightly slower application response times.

The queries have an invalid searchspec where the table name is being compared against business component names.

Some examples follows:

The S_RR_TABLE table is expected to contain the runtime compiled definition of the repository tables.
The column "NAME" is expected to contain table names and not business component names.

There are no specific steps to replicate. 

The queries are generated while users navigate the application. 

No errors are observed but performance monitoring tools suggest a slight decrease in response time.




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

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