Re: dbms_stats.gather_table_stats

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.

Finn

On Fri, Sep 5, 2008 at 2:00 PM, <genegurevich_at_discover.com> wrote:

> Hi everybody:
>
> I am running oracle 10.2.0.1. 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 );
>

--
http://www.freelists.org/webpage/oracle-l