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.
0 Comments
Leave a Reply. |