OPTIMIZER_DYNAMIC

OPTIMIZER_DYNAMIC_SAMPLING

Property	Description
Parameter type	Integer
Default value	If `OPTIMIZER_FEATURES_ENABLE` is set to `10.0.0` or higher, then `2` If `OPTIMIZER_FEATURES_ENABLE` is set to `9.2.0`, then `1` If `OPTIMIZER_FEATURES_ENABLE` is set to `9.0.1` or lower, then `0`
Modifiable	`ALTER SESSION`, `ALTER SYSTEM`
Range of values	`0` to `10`

OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.

See Also:

Oracle Database Performance Tuning Guide for more information on setting this parameter