Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.net!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!i3g2000cwc.googlegroups.com!not-for-mail From: "joel garry" Newsgroups: comp.databases.oracle.server Subject: Re: dbms_stats.gather_schema_stats Date: 10 Oct 2006 16:05:13 -0700 Organization: http://groups.google.com Lines: 21 Message-ID: <1160521513.089529.36790@i3g2000cwc.googlegroups.com> References: <12ini8ekve2oe88@corp.supernews.com> NNTP-Posting-Host: 67.116.125.178 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1160521518 25676 127.0.0.1 (10 Oct 2006 23:05:18 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 10 Oct 2006 23:05:18 +0000 (UTC) In-Reply-To: <12ini8ekve2oe88@corp.supernews.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.0 ISA2K4-OC1 Complaints-To: groups-abuse@google.com Injection-Info: i3g2000cwc.googlegroups.com; posting-host=67.116.125.178; posting-account=YRNZ5wwAAAAg-yYjMFwy3FyWUbPiwNdq Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276990 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