dbs/ora/substitute_literals

Parameter

dbs/ora/substitute_literals

Short text

global setting for openSQL hint SUBSTITUTE_LITER

Parameter Description

Same behavior as the OpenSQL pseudo hint SUBSTITUTE_LITERALS, but with global validity (that is, for every statement)

• 1 ==> Literals are always transferred to the Oracle Shared Pool as they are, they are never replaced with host variables. (-> for Optimizer purposes)
• 0 ==> Default behavior: Literals are replaced by host variables unless the pseudo hint SUBSTITUTE_LITERALS is used in the SQL statement.

Application Area

Perf

Default Value

0

Values allowed

{ 0, 1 }