This is version 1 2 3 4 . It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

Indici#

AUTO_RUNSTATS#

This hierarchy (shown by the indentation of the parameters in the output from this command) allows a DBA to enable or disable automatic table maintenance features selectively or as a group. For example, if AUTO_MAINT is set to OFF, all other automatic maintenance parameters are considered to have an effective value of OFF, regardless their actual value. Similarly, if AUTO_TBL_MAINT is set to OFF, the AUTO_RUNSTATS, AUTOSTATS_PROF, AUTO_PROF_UPD and AUTO_REORG parameters are considered to have an effective value of OFF. To enable automatic statistics collection, the AUTO_MAINT, AUTO_TBL_MAINT and AUTO_RUNSTATS parameters must all have a value of ON.

You can enable automatic statistics collection by issuing the following command:

CONNECT TO
UPDATE DB CONFIG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_RUNSTATS ON