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

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

Re: Which is the frequency to execute GATHER_DICTIONARY_STATS & GATHER_FIXED_OBJECTS_STATS

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 22 Nov 2005 08:32:14 -0400
Message-ID: <cd4305c10511220432n7ece7c54v1b04caffdda22d21@mail.gmail.com> 





Mogens,


I understand the advice is to trace, this means gather statistics now
and trace now, and every month for example and see if execution plans
goes worst, if they goes worst then is time to gather statistics
again?


Thank you :)

--
http://www.freelists.org/webpage/oracle-l


Received on Tue Nov 22 2005 - 06:34:20 CST












Original text of this message













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