RE: DBMS_STATS
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 06 May 2004 14:41:36 -0600
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@xxxxxxxxxxxxx> wrote:
regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
