RE: dbms.stats.gather_system_stats jobs

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <rstauffer@xxxxxxxxxxxxxxxxxxxx>
  • Date: Fri, 1 Jun 2007 10:14:51 +0200

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: