Re: DBMS_STATS
From: Palooka <nobody_at_nowhere.com>
Date: Tue, 29 Sep 2009 00:04:54 +0100
Message-ID: <qibwm.350024$156.239359_at_newsfe14.ams2>
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.
Date: Tue, 29 Sep 2009 00:04:54 +0100
Message-ID: <qibwm.350024$156.239359_at_newsfe14.ams2>
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 Received on Mon Sep 28 2009 - 18:04:54 CDT