Statistics gathering in production before 11g.

sakthikumar
sakthikumar used Ask the Experts™
on
In 11g we have automated job to update table and index statistics. Before 11g, especially
in OLTP environments, how statistics is collected? what is the normal process followed in general?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Production Manager / Application Support Manager
Commented:
either dbms_stats package with its procedures/functions or even before that is like analyze commands.

check this for more info :

http://www.oracle-base.com/articles/misc/cost-based-optimizer-and-database-statistics.php
http://docs.oracle.com/cd/B10500_01/server.920/a96533/stats.htm
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
The default maintenance window started in 10g:

The 10gR1 New Features Guide:
http://docs.oracle.com/cd/B12037_01/server.101/b10750/chapter1.htm

Automatic Routine Administration Tasks

The database Scheduler can schedule routine administration tasks, such as collecting optimizer statistics during a pre-defined maintenance window.

10gR2 Admin guide:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/tasks.htm

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial