Re: Usage of the dbms_stats.gather_database_stats() procedure

I've not used the auto sample size at all, but I am using the gather_stale in some cases.

I would turn monitoring on and see how much the data is actually changing in your tables. In general, I've gotten the best results by getting complete statistics with historgrams and leaving them alone. I only regather stats on tables that have very changable data.

Robyn

On 2/13/06, Orr, Steve <sorr_at_rightnow.com> wrote:
>
> Follow up question…
>
> Once I get stats up to date I want set up a maintenance routine. For
> ongoing maintenance on a nightly or weekly basis has anyone used something
> like…
>
> gather_DATABASE_stats(dbms_stats.auto_sample_size, -
>
> options=>'gather_stale', cascade=>true);
>
>
>
> Any other stats maintenance recommendations?
>
>
>
> TIA
>

--

Robyn Anderson Sands
email: Robyn.Sands_at_SciAtl.com
--
http://www.freelists.org/webpage/oracle-l