Peter Bach On Statistics Collection Strategies
February 28th, 2005 by Mark Rittman
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".
