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_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 );