Re: segment monitoring, stats, histograms

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: thomas.mercadante@xxxxxxxxxxxxxxxxx
  • Date: Fri, 04 Feb 2005 07:44:24 -0700

As Jonathan so diplomatically said in a post in this list "most of the 
time it doesn't do any harm". The question that always comes to my mind is
is it necessary, i.e. would any plans go bad if you DIDN'T analyze?
My conjecture, of course, is that few, if any, would.

Of course that is a philisophical question. If your current practice 
isn't causing any trouble you don't change it just to find out if a 
different practice would, or not, cause any trouble. I wouldn't do that 
either.

Mercadante, Thomas F wrote:

> Jeremiah,
> 
> I have all tables in monitoring mode.  And I gather stats daily using the
> USER_TAB_MODIFICATIONS table.  Granted that I have mostly OLTP databases,
> but I have not yet run into a situation where the execution plan changed to
> something bad because of new stats being gathered.  Monitoring has not
> impacted DML operations.  And we perform a full stats gather - I never
> sample.  I don't gather histogram stats as I have not had the need yet.
> 
> Runs fine for us.
> 

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2005