Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-04 |
|
|
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