Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stats.gather_schema_stats

Re: dbms_stats.gather_schema_stats

From: klabu <nosuchuser_at_gmail_dot_com>
Date: Tue, 10 Oct 2006 12:50:33 -0400
Message-ID: <12injqqdhd57s11@corp.supernews.com>


<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US