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 -> dbms_stats.gather_schema_stats

dbms_stats.gather_schema_stats

From: klabu <nosuchuser_at_gmail_dot_com>
Date: Tue, 10 Oct 2006 12:23:41 -0400
Message-ID: <12ini8ekve2oe88@corp.supernews.com> 






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 ?
Received on Tue Oct 10 2006 - 11:23:41 CDT












Original text of this message













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