Newsgroups: comp.databases.oracle.server Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: dbms_stats.gather_schema_stats In-Reply-To: <12ini8ekve2oe88@corp.supernews.com> X-Nntp-Posting-Host: edc-cv-160-53.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <12ini8ekve2oe88@corp.supernews.com> Mime-Version: 1.0 Date: Tue, 10 Oct 2006 16:43:42 GMT Lines: 36 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276954 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 ? > > Which version of Oracle? As David already said, it can take a long time gather stats for an entire schema, depending on many factors. The primary factor is the size of the segments in the schema, but it is not the only one. There are methods to gather schema stats faster. You can perform the operation in parallel. You can only gather "stale" stats. These are just a few. HTH, Brian -- =================================================================== Brian Peasland dba@nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown