RE: dbms.stats.gather_system_stats jobs

Hi Bob

> AUTO_STOP
This job is used to stop the gathering. This is basically the same as the mode STOP (which is documented).

> flush_cache

This job modifies either sys.cache_stats_0$ or sys.cache_stats_1$. Their aim is to store caching information at object level.

Notice that:
- This job is removed when the AUTO_STOP job runs. - This job is also available if the gathering is performed manually with the mode START.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l