Gather Statistics

Gather Statistics :

Important Documents:

• What is the Gather Statistic Program or Gather Schema Statistics? (Doc ID 155766.1) 
• How Often Should Gather Schema Statistics Program be Run? (Doc ID 168136.1) 
• Gather Schema Statistics with LASTRUN Option does not Clean FND_STATS_HIST Table (Doc ID 745442.1) 
• Does Gather Schema Statistics collect statistics for indexes? (Doc ID 170647.1) 
• Definition of Parameters Used in Gather Schema Statistics Program (Doc ID 556466.1) 
• Gathering Schema or Database Statistics Automatically in 8i and 9i - Examples (Doc ID 237901.1) 
• Gather Schema Statistics Fails for Some Tables Percentages Not Displaying Properly (Doc ID 149603.1) 
• Gather Schema Statistics (FNDGSCST) Hangs with DR$ Tables With Monitoring (Doc ID 435482.1) 
• Gather Schema Statistics Hangs & Returns ORA-600: Internal Error, Arguments: [25012] (Doc ID 454205.1) 
• Gather schema statistics occupies huge TEMP space without releasing it (Doc ID 731674.1) 
• Gather Schema Statistics Completed Err ORA-20000 Index in unusable state (Doc ID 373488.1) 
• How To Gather Table Statistics For Custom Schema Tables (Doc ID 389944.1) 
• Gather Schema Statistics Program Fails When Scheduled (Doc ID 1050582.1) 
• Running Gather Optimizer Statistics On Schema Generates Error (Doc ID 854527.1) 
• Gather Schema Statistics Fails With Errors ORA-04063 and ORA-04068 (Doc ID 215897.1)