Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xt-sjc-05!sn-xt-sjc-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: dbms_stats.gather_schema_stats
Date: Tue, 10 Oct 2006 12:23:41 -0400
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <12ini8ekve2oe88@corp.supernews.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: 10
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276948


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 ?