OPTIMIZER_USE_PENDING_STATISTICS

Property Description
Parameter type Boolean
Default value false
Modifiable ALTER SESSION, ALTER SYSTEM
Range of values true | false
Basic No

OPTIMIZER_USE_PENDING_STATISTICS specifies whether or not the optimizer uses pending statistics when compiling SQL statements.

See Also:

Oracle Database Performance Tuning Guide for more information on setting this parameter