Database Settings and Oracle Hidden parameters
(Doc ID 483686.1)
Last updated on AUGUST 27, 2018
Applies to:Siebel Tools - Version 220.127.116.11  and later
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 18.104.22.168 
Database: Oracle 10.2.0.1
Application Server OS: IBM AIX 5L 5.3
Database Server OS: IBM AIX 4.3.1
Checked for Relevance on 14-Apr-2010
Checked for Relevance on 29-May-2013
Checked for Relevance on 05-May-2016
*** Checked for relevance on 27-Aug-2018 ***
This document was previously published as Siebel SR 38-3255763951.
While searching a contact by phone number, by email address, by last name etc, it would result a LIKE clause to be included in the predicate, causing long running queries. Although the columns in which this LIKE clause is applied are indexed, they are not picked up as per the execution plan. The DBA suggested that enabling "_like_with_bind_as_equality"=TRUE results the correct execution path and ensures fast performance.
Since this is an un-documented parameter, is there any possible side-effects/impacts of setting this parameter?
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