| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_STATS
I know I'm waaaayyy late responding to this one, but I've been busier than usual the past few weeks. But I must ask one question (and anyone can hop in on this one!!) . . . You, and several others whose opinions I value, seem to have been quite successful with this don't-over-analyze-the-database approach. Why then does Oracle choose in 10g to automatically collect statistics every night, whether you want it to do so or not?? (See Mr. Freeman's book on 10g New Features, pp.18-19 -- or the pile of trace files that accumulated in my bdump directory shortly after migrating my dev instance!!) You can go in manually and change it, but I prefer doing my own configuration (rather than have it thrust upon me). Needs may vary widely among instances within an enterprise (i.e. between OLTP and datawarehouse applications) or even among schemas within a database (one app I administer has some tablespaces that are read-only, and others that experience significant inserts and updates d
aily).
Thanks in advance for any insights.
Joe Cooper
Senior Oracle DBA
Sheshunoff Information Services
(A Thomson Media company)
Austin, TX
Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
If you had read my presentation/paper you would know that I argue against the practice of analyzing on a daily/weekly schedule to keep stats up-to-date. Most stats in the database I had been managing until last fall were over 2 years old.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Thu May 06 2004 - 15:25:34 CDT
-----------------------------------------------------------------
 |
 |