Re: dbms_stats.gather_schema_stats

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 ?

Yes. You might consider making it longer with cascade=>true so your indices get it. You shouldn't be doing it during heavy production times.

The old ANALYSE didn't do as much.

jg

--
@home.com is bogus.
Does Yahoo do you?  http://yro.slashdot.org/yro/06/10/10/2042248.shtml