Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Statistics gathering in production before 11g.

Posted on 2014-03-05
2
311 Views
Last Modified: 2014-03-22
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
Comment
Question by:sakthikumar
2 Comments
 
LVL 28

Accepted Solution

by:
Naveen Kumar earned 250 total points
ID: 39908524
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
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 39909147
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question