Job Console

Job Manager

Task Manager

Utilities Console

UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

Self-tuning is occurring only on the instance memory area.

The memory tuner is actively tuning the memory on the system.

Self-tuning is not occurring because it is waiting for the database to be recycled.

Self-tuning is not occurring because there are less than two memory consumers enabled.

Set

Tree

Group

Range

Hierarchy

In the table definition

In the system catalog

In the table space metadata

In the database configuration file