Statistics gathering in production before 11g.

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?
sakthikumarAsked:
Who is Participating?
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
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
0
 
slightwv (䄆 Netminder)Connect With a Mentor 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.