Database Settings and Oracle Hidden parameters
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 126.96.36.199  and later
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 188.8.131.52 
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
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?
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