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: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Mon, 21 Nov 2005 12:15:31 -0000
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63030F10CF@UKWMXM04>


Oracle suggests the following best practices for collecting statistics. http://www.oracle.com/technology/books/pdfs/book_10g_chap9_ce1.pdf  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes Pacheco
Sent: 17 November 2005 19:30
To: oracle-l_at_freelists.org
Subject: Which is the frequency to execute GATHER_DICTIONARY_STATS & GATHER_FIXED_OBJECTS_STATS   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      

--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 21 2005 - 06:17:45 CST

Original text of this message

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