Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Which is the frequency to execute GATHER_DICTIONARY_STATS & GATHER_FIXED_OBJECTS_STATS

Which is the frequency to execute GATHER_DICTIONARY_STATS & GATHER_FIXED_OBJECTS_STATS

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Thu, 17 Nov 2005 15:30:23 -0400
Message-ID: <cd4305c10511171130v1f77f934yaaf686fd6e721939@mail.gmail.com> 





Hi, please can some body share some rules about running this
dbms_stats procedures.



In documentation says, you have to run....
but I still don't got, how frequently, or if some background process
does it periodically so the only thing you have to do is for example
ste statistics level to typical or all.



Thank you




--



Oracle Certified Profesional 9i 10g


Orace Certified Professional Developer 6i



8 years of experience in Oracle 7,8i,9i,10g and developer 6i


--



http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 17 2005 - 14:33:41 CST












Original text of this message













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