| 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 am not too happy about this automatically analyzing. I suppose I would
lock all tables to prevent the automatic updates and continue to do
statistics gathering manually when I see and verified the need.
At 02:28 PM 5/6/2004, you wrote:
>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:
regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu May 06 2004 - 15:39:10 CDT
 |
 |