Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stats.gather_schema_stats
<fitzjarrell_at_cox.net> wrote in message
> 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.
>
well i did quote the word "normal" precisely because I knew this is a
relative term in this context
** I just have no prior experience with "dbms_stats" to tell if this is
"normal" or "out-of-whack"
I used to do "DBMS_UTILITY.ANALYZE_SCHEMA" and I don't think it ever took this long for this amount of data.
This is 10gR2 BTW. Received on Tue Oct 10 2006 - 11:50:33 CDT