streamlined dynamic SQL

streamlined dynamic SQL enables the statement cache to store dynamic SQL statements.

Summary Information

Default value

0 (off)

Valid values

0 (off), 1(on)



Display level


Required role

System administrator

Configuration group

Application Functionality

Note: The default value for streamlined dynamic SQL depends on the value to which enable functionality group is set. If you set enable functionality group to:

However, if you set streamlined dynamic SQL to 1, it uses a value of 1 regardless of what you set enable functionality group to.

See enable functionality group.

See Performance and Tuning Series: Basics > Memory Use and Performance.