To manage published and pending statistics: Table 15-2 Views Relevant for Publishing Optimizer Statistics Viewĭisplays optimizer statistics for the tables accessible to the current user.ĭisplays column statistics and histogram information extracted from ALL_TAB_COLUMNS.ĭisplays column statistics and histogram information for the table partitions owned by the current user.ĭescribes column statistics and histogram information for subpartitions of partitioned objects owned by the current user.ĭisplays optimizer statistics for the indexes accessible to the current user.ĭescribes pending statistics for tables, partitions, and subpartitions accessible to the current user.ĭescribes the pending statistics of the columns accessible to the current user.ĭescribes the pending statistics for tables, partitions, and subpartitions accessible to the current user collected using the DBMS_STATS package. You can use access information about published statistics from data dictionary views. The best practice is to set this parameter at the session level rather than at the database level.

Set to true to specify that the optimizer uses any existing pending statistics instead.

The default value is false, which means that the optimizer uses only published statistics. The initialization parameter OPTIMIZER_USE_PENDING_STATISTICS determines whether the database uses pending statistics when they are available. Publish valid pending statistics for all objects or only specified objects. Set the PUBLISH setting to true or false at the schema level. Set the PUBLISH setting to true or false at the table level. For the parameter PUBLISH, true indicates that the statistics must be published when the database gathers them, whereas false indicates that the database must keep the statistics pending. Table 15-1 DBMS_STATS Program Units Relevant for Publishing Optimizer Statistics Program UnitĬheck whether the statistics are automatically published as soon as DBMS_STATS gathers them.

Download Optimizer 15.3