[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

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?
0
sakthikumar
Asked:
sakthikumar
2 Solutions
 
Naveen KumarProduction 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) 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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now