2.11 OPTIMIZER_DYNAMIC_SAMPLING
This controls the level of dynamic sampling performed by the optimizer.
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | If OPTIMIZER_FEATURES_ENABLE is set to 10.0.0 or higher, then 2
If OPTIMIZER_FEATURES_ENABLE is set to 9.2.0, then 1 If OPTIMIZER_FEATURES_ENABLE is set to 9.0.1 or lower, then 0 |
| Recommended Values | 1 |
| Range of values | 0 to 10 |
Oracle Banking Trade Finance relevance
Dynamic Sampling is a method of gathering additional statistics during optimization by recursively sampling statements. When dynamic sampling is enabled, queries are recursively generated by Oracle to test various selectivity based upon real values in order to improve their accuracy. This can result in the production of better explain plans.
Value 1 Sample all tables that have not been analyzed that meet certain criteria.
Parent topic: Database Initialization Parameters