Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-03 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | Integer |
Default value | If OPTIMIZER_FEATURES_ENABLE is set to 10.0.0 or higher, then 2
If If |
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