Re: Which is the frequency to execute GATHER_DICTIONARY_STATS & GATHER_FIXED_OBJECTS_STATS
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: Mogens Nørrgaard <mln@xxxxxxxxxxxx>
- Date: Tue, 22 Nov 2005 08:32:14 -0400
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 :)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
