Database Settings and Oracle Hidden parameters (Doc ID 483686.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.8.2.3 [19221] and later
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221]
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.


Goal

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?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms