Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Usage of the dbms_stats.gather_database_stats() procedure
typo ... s/b without histograms.
my bad ... robyn
On 2/13/06, Robyn <robyn.sands_at_gmail.com> wrote:
>
> 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
>
-- Robyn Anderson Sands email: Robyn.Sands_at_SciAtl.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 13 2006 - 12:21:10 CST
![]() |
![]() |