Peter Bach On Statistics Collection Strategies

Investigation of collecting Cost Base Optimizer statistics : "This article looks at some of the questions and challenges you need to consider when you are planning statistics collection for Oracle's Cost Based Optimizer (CBO). Many businesses require 24 by 7 operations which often put constraints on the available timeframe and hardware resources for collecting CBO statistics. The purpose of this investigation is to:

• Highlight how Oracle's statistics collection methods dbms_stats and analyze work.
• Test and analyse ways to produce quality statistics, within a reasonable time-frame."

An excellent article by Peter Bach on the various statistics collection strategies available with Oracle 9i and 10g. See also Jonathan Lewis' "Gathering Statistics: How Often and How Precise".