Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
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.Note:
1. This parameter was introduced in 11g.2. Query for the current value of the parameter
select name, value, isdefault, isses_modifiable, issys_modifiable,
isinstance_modifiable, isdeprecated, description
from v$parameter
where upper(name) = ‘OPTIMIZER_USE_PENDING_STATISTICS’;
