Statistics - User Object, System, Fixed Object, and Dictionary Statistics Topics

User Object Statistics

http://www.dba-oracle.com/t_gather_stats_job.htm
Improvement of AUTO sampling statistics gathering on 11g - The Oracle Optimizer Development Group

Statistics on Partitioned Tables

Managing Statistics on Large Partitioned Tables - The Oracle Optimizer Development Group
Oracle 11g Incremental Global Statistics on Partitioned Tables - Greg Rahn
Data Warehousing and Statistics in Oracle 11g - Robin Moffatt
11g Incremental Partition Statistics Review - Randolf Geist
Managing Optimizer Statistics in Oracle Database 11g - Maria Colgan
-- Turn on incremental stats for all partitioned tables > 500mb
  SELECT OWNER, SEGMENT_NAME, SUM (BYTES) / 1024 / 1024 / 1024 AS GB, 
  DBMS_STATS.GET_PREFS('INCREMENTAL', OWNER, segment_name) AS INCREMENTAL
    FROM DBA_SEGMENTS
   WHERE SEGMENT_TYPE = 'TABLE PARTITION' AND SEGMENT_NAME NOT LIKE '%$%'
GROUP BY OWNER, SEGMENT_NAME
  HAVING SUM (BYTES) / 1024 / 1024 / 1024 >= 0.5
ORDER BY 3 DESC;

BEGIN
  FOR cur IN (
    SELECT OWNER, SEGMENT_NAME, SUM (BYTES) / 1024 / 1024 / 1024 AS GB
      FROM DBA_SEGMENTS
     WHERE SEGMENT_TYPE = 'TABLE PARTITION' 
       AND SEGMENT_NAME NOT LIKE '%$%'
  GROUP BY OWNER, SEGMENT_NAME
    HAVING SUM (BYTES) / 1024 / 1024 / 1024 >= 0.5)
  LOOP
    DBMS_OUTPUT.PUT_LINE('Processing '||cur.SEGMENT_NAME);
    DBMS_STATS.set_table_prefs(cur.owner, cur.segment_name, 'INCREMENTAL', 'TRUE');

  END LOOP;
END;
/

System Statistics

Recording Oracle System Stats for Historical Analysis

Fixed Object Statistics

Oracle Optimizer Blog - Fixed Object Statistics and Why They Are Important

Dictionary Statistics

exec dbms_stats.gather_dictionary_stats;

More Statistics Topics...