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 kommentar(er)
