Parameter
dbs/ora/substitute_literals

Short text
global setting for openSQL hint SUBSTITUTE_LITERSame 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 hintSUBSTITUTE_LITERALS is used in the SQL statement.

Work area
Perf

Valid_values
{ 0, 1 }