Search notes:

Oracle: Init parameter OPTIMIZER_DYNAMIC_SAMPLING

The default value of optimizer_dynamic_sampling is dependent on the value of optimizer_features_enable:
if then
9.0.1 or lower 0
9.2.0 1
10.0.0 or higher 2

See also

The SQL hint dynamic_sampling.
Dynamic optimizer statistics
init parameters

Index