My Oracle Support Banner

Oracle ALL_ROWS hint in Siebel SQL Queries (Doc ID 495455.1)

Last updated on JUNE 06, 2024

Applies to:

Siebel Tools - Version 7.8.2.3 [19221] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221]
Database: Oracle 10.1.0.4
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: HP-UX 11i

 


Goal

While monitoring the Oracle database we noticed that Siebel often produces SELECT statements with the ALL_ROWS oracle hint, such as the following:

In bigger queries, this hint appears to be causing significant delays for no apparent reason, therefore we'd rather it was not included in the query.

How can we control the inclusion of this hint in Siebel Queries e.g. from Siebel Tools?

Solution

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
Goal
Solution
References

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