Hi,

what is the general rule about calculate statistics on
the dictionnary in 9i and 10g ?

Thanks in advance

On Nov 23, 4:03*pm, "bob123" <nom... (AT) nowhere (DOT) com> wrote:
so, what statistics are you looking for? hopefully you are no longer
using dictionary-managed tablespaces in your 9i db (which is woefully
out of date and out of support).

On Nov 23, 4:03*pm, "bob123" <nom... (AT) nowhere (DOT) com> wrote:
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....599d3e043fc199

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.

On Nov 24, 9:43*am, Charles Hooper <hooperc2... (AT) yahoo (DOT) com> wrote:
With 9i I believe most shops are better off not generating statistics
on the Oracle base tables. However some Oracle Applications require
the generation of statistics on sys objects so if your Oracle
documentation specifies generating the statistics I would do so, but
in the absence of Oracle products which require doing so I would not
generate statistics on the base tables.

HTH -- Mark D Powell --

OK thanks Charles and Mark

"Mark D Powell" <Mark.Powell2 (AT) hp (DOT) com> a écrit dans le message de groupe de
discussion :
10e9595f-e903-4c66-a3af-6579f8e90086...oglegroups.com...