Oracle ALL_ROWS hint in Siebel SQL Queries
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 188.8.131.52  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 184.108.40.206 
Database: Oracle 10.1.0.4
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: HP-UX 11i
Checked for relevance on 17-Mar-2014.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms