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
--
http://www.freelists.org/webpage/oracle-l
Other related posts: