| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
| 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