Gathering schema statistics

Gathering schema statistics

There is no set schedule for gathering schema statistics.  
On some systems the program should be run weekly.  
On other systems once per month will be often enough.  
The schedule will vary greatly depending on the amount and nature of the data 
and how often the data changes.  

It will be necessary to try different schedules over time and monitor 
performance to determine the most effective schedule.

As a general rule, run Gather Schema Statistics under the following circumstances:

1. After there has been a significant change in data in either content or 
   volume.

2. After importing data. 

3. Any time end-users notice a deterioration in performance in routine day-to-
   day business transactions or when running concurrent programs.
   

Note that the ANALYZE command and DBMS_STATS packages are not supported in
Release 11i.  FND_STATS should be used instead.  The Gather Schema Statistics
program uses FND_STATS.