Re: DBMS_STATS
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Mon, 28 Sep 2009 15:15:24 -0700 (PDT)
Message-ID: <dd730056-8596-49a4-b266-54fdfd3e11e6_at_h13g2000yqk.googlegroups.com>
On Sep 28, 11:42 am, The Magnet <a..._at_unsu.com> 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?
Date: Mon, 28 Sep 2009 15:15:24 -0700 (PDT)
Message-ID: <dd730056-8596-49a4-b266-54fdfd3e11e6_at_h13g2000yqk.googlegroups.com>
On Sep 28, 11:42 am, The Magnet <a..._at_unsu.com> 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?
Here is a guy from the optimizer internals group ... giving the "currently recommended way"
http://structureddata.org/2008/03/26/choosing-an-optimal-stats-gathering-strategy/
Think about using dbms_stats.set_param('AUTOSTATS_TARGET','ORACLE') if you want to manage your own schema based stats but let oracle gather system related ones. Received on Mon Sep 28 2009 - 17:15:24 CDT