Re: DBMS_STATS
From: gazzag <gareth_at_jamms.org>
Date: Tue, 29 Sep 2009 03:26:31 -0700 (PDT)
Message-ID: <1fd1d77a-fa3f-4c80-9c69-243f70efbd2a_at_l2g2000yqd.googlegroups.com>
On 29 Sep, 00:04, Palooka <nob..._at_nowhere.com> wrote:
> On 28/09/09 16:42, The Magnet wrote:
>
> > Probably a dumb question here, but we're trying to understand
> > DBMS_STATS and all the parameters and such. What a complicated
> > thing. Too many parameters to understand the effects.
>
> > Anyhow, I read that Oracle 10g generates database stats each night.
> > What kind of stats? Does this mean I do not have to compute schema
> > stats?
>
> If I were you, I wouldn't bother at all. Oracle is clearly much too hard
> if you actually have to read the documentation.
>
> Palooka
Date: Tue, 29 Sep 2009 03:26:31 -0700 (PDT)
Message-ID: <1fd1d77a-fa3f-4c80-9c69-243f70efbd2a_at_l2g2000yqd.googlegroups.com>
On 29 Sep, 00:04, Palooka <nob..._at_nowhere.com> wrote:
> On 28/09/09 16:42, The Magnet wrote:
>
> > Probably a dumb question here, but we're trying to understand
> > DBMS_STATS and all the parameters and such. What a complicated
> > thing. Too many parameters to understand the effects.
>
> > Anyhow, I read that Oracle 10g generates database stats each night.
> > What kind of stats? Does this mean I do not have to compute schema
> > stats?
>
> If I were you, I wouldn't bother at all. Oracle is clearly much too hard
> if you actually have to read the documentation.
>
> Palooka
You are Sybrand Bakker and I claim my 5 Euros :) Received on Tue Sep 29 2009 - 05:26:31 CDT