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 -> Re: stale statistics in KOTTD$ table

Re: stale statistics in KOTTD$ table

From: News <Contact_404_at_hotmail.com>
Date: 22 Dec 2005 02:11:28 -0800
Message-ID: <1135246288.048077.140950@o13g2000cwo.googlegroups.com> 





>Run DBMS_STATS.GATHER_DATABASE_STATS.




Do you really think it will resolve the problem ? The DB is 1,5 TB this
command is running for 3 hours already .. I have to issue the same
command on 8 bigger DB up to 3TB. Is there quicker solution ?
Received on Thu Dec 22 2005 - 04:11:28 CST












Original text of this message













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