Re: dbms_stats.gather_schema

From: <fitzjarrell_at_cox.net>
Date: 10 Oct 2006 09:34:51 -0700
Message-ID: <1160498091.074579.58040@h48g2000cwc.googlegroups.com>

klabu wrote:
> I have 15 tables, about 7 mil rows in total
>
> SQL> exec dbms_stats.gather_schema_stats(user);
>
> Executed in 469.305 seconds
>
> Is it "normal" that dbms_stats.gather_schema_stats takes that long ?

Define 'normal' in that context. You're computing statistics on an entire schema, not simply a single table. The dbms_stats.gather_schema_stats procedure does not 'fold time and space' to provide instantaneous response.

David Fitzjarrell Received on Tue Oct 10 2006 - 11:34:51 CDT

Re: dbms_stats.gather_schema_stats