Re: Where does GC grab historical SQL plans from?

> The first thing I do, provided I work with DBAs who listen ( not always the
> case as a consultant ), is to turn off histogram collection in the
> dbms_stats defaults ( method_opt=>'for all columns size 1' ).
>
> There are several problems with the out-of-the-box default of 'for all
> columns size auto':
> ...
> the shared pool, etc. All that can be avoided if you turn "global"
> histograms off and only collect histograms for specific columns where it has
> been proven that they help.

As luck would have it, the upgrade to 11.2 is the perfect opportunity for me to do this, along with bitbucketing other unfortunate undesirables.

Putting this on my Upgrade List for testing.

Thanks again!
Rich

--
http://www.freelists.org/webpage/oracle-l