Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stats.gather_schema_stats
"klabu" <nosuchuser_at_gmail_dot_com> wrote in message
news:12ini8ekve2oe88_at_corp.supernews.com...
>
> 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 ?
>
>
Depends on your hardware, number of columns, indexes, ...
So yes, it can take this long. But you don't need to execute it each day, only when there are significant data changes. Received on Tue Oct 10 2006 - 13:39:27 CDT