Re: Dictionnary statistics
Date: Wed, 24 Nov 2010 06:43:20 -0800 (PST)
Message-ID: <3ee78539-a55d-47e6-8de1-133b11b4c63f_at_a12g2000vbc.googlegroups.com>
On Nov 23, 4:03 pm, "bob123" <nom..._at_nowhere.com> wrote:
> Hi,
>
> what is the general rule about calculate statistics on
> the dictionnary in 9i and 10g ?
>
> Thanks in advance
I assume that you are asking about the data dictionary statistics and fixed object statistics. On 10g and above you definitely will want to collect statistics those statistics, see this thread from 2008: http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/e0599d3e043fc199
On 8i you should not collect statistics on the data dictionary. Based on previous discussions on this forum, statistics collection on the data dictionary in 9i may or may not be a good idea. Hopefully, someone else who is still working with 9i will reply with a better/ more complete answer.
Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration
from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Wed Nov 24 2010 - 08:43:20 CST