OPTIMIZER_DYNAMIC_SAMPLING

Parameter type	Integer
Default value	If OPTIMIZER_FEATURES_ENABLE is set to 9.2.0 or higher, then 1 If OPTIMIZER_FEATURES_ENABLE is set to 9.0.1 or lower, then 0
Parameter class	Dynamic: 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: Oracle9i Database Performance Tuning Guide and Reference for more information on setting this parameter