Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stueberl.de!newsgate.cistron.nl!xs4all!news2.euro.net!138.199.65.86.MISMATCH!sn-xt-ams-06!sn-xt-ams-08!sn-post-ams-01!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail
From: "klabu" <nosuchuser_at_gmail_dot_com>
Newsgroups: comp.databases.oracle.server
Subject: Re: dbms_stats.gather_schema_stats
Date: Tue, 10 Oct 2006 12:50:33 -0400
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <12injqqdhd57s11@corp.supernews.com>
References: <12ini8ekve2oe88@corp.supernews.com> <1160498091.074579.58040@h48g2000cwc.googlegroups.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Complaints-To: abuse@supernews.com
Lines: 22
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276953

<fitzjarrell@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.