Gathering statistics on 8.1.7.4
- From: "Schauss, Peter" <peter.schauss@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 May 2007 11:22:42 -0400
I am starting to generate statistics on an 8.1.7.4 database and I have a
few questions.
- Should I be using the dbms_stats package or the analyze command for
this version of Oracle?
- Looking at some of the threads in the archives, I note that people do
not generally recommend histograms. If I use
dbms_stats.gather_schema_stats, how do I set the method_opt parameter so
that I do not generate histograms?
- What is a good starting point for "estimate_percent"? This is a 70gb
databsae used for a data warehouse application. Data is added from the
production database every hour and we have a growth rate of about 20%
per year.
Thanks,
Peter Schauss
--
http://www.freelists.org/webpage/oracle-l
Other related posts: