Re: dbms_stats.gather_table_stats

  • From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
  • To: genegurevich@xxxxxxxxxxxx
  • Date: Sun, 7 Sep 2008 08:48:03 -0500

Are you aware that Oracle 10gR2 automatially gathers stats on objects that
are "stale" unless you've turned this feature off?

You may be doing something that's already done automatically.


On Fri, Sep 5, 2008 at 2:00 PM, <genegurevich@xxxxxxxxxxxx> wrote:

> Hi everybody:
> I am running oracle Once a week we have a analyze process run to
> gather stats on all the
> tables in the schema via commands like this one exec
> dbms_stats.gather_table_stats( 'schema', 'table',            null, 25,
> degree=>8, cascade=>true );

Other related posts: