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