Re: 11G Statistics Collection

From: Mladen Gogala <>
Date: Sun, 15 Apr 2012 22:17:55 +0000 (UTC)
Message-ID: <>

On Sun, 15 Apr 2012 04:03:12 -0700, Noons wrote:

> Neither is it desirable. This fixation with "collect statistics every
> day to resolve all performance ills" is getting beyond ridiculous... I'm
> always reminded of Peoplesoft - an ORACLE product, let's not forget it!
> - where temp tables are used all over the place. Truncated, populated,
> then queried upon and cleared after.
> Yeah right, of course the DBA needs to calculate stats every day. Right
> when they are empty! It's such a great way of stuffing up
> performance!...

I thought that dynamic sampling was the right way to deal with the temporary tables? If you enable dynamic sampling, you will add yet another element of unpredictability to your system. There may be more than the STALE_PERCENT of changes and Oracle will decide that it doesn't really want to use the stats and histograms you provided, it will sample it dynamically, which will make the application performance dynamically f**ed.

Received on Sun Apr 15 2012 - 17:17:55 CDT

Original text of this message