In article <3DanXDAIF5n2Iw2H_at_coalole.demon.co.uk>,
Diane <Diane_at_coalole.demon.co.uk> wrote:
> In article <369E1252.2309_at_groton.pfizer.com>, Darryl E Balaski
> <darryl_e_balaski_at_groton.pfizer.com> writes
> >I agree with Terry -- Never analyze the oracle Internal Objects.
> >
> >As I said before, the problem can reside in many areas -- first and
> >foremost being a possible undersized shared_pool -- good chance you
> >would wish to increase it.
> >Although, there are a plethera of other reasons that would effect
> >performance
> >(block size, too small buffer cache, etc etc)
> >
> >darryl dB Balaski
> >www.rdbms.org
> >
> >Terry Ball wrote:
> >>
> >> NO, NO, NO. Never analyze the sys (dictionary included) tables.
> >> If the dictionary tables (or any sys tables) have statics on them, you
> >> should consider deleting those stats.
> >>
> >> Terry Ball
> >> Sr. DBA, CSG Systems
> >>
> >> Diane wrote:
> >> > In article <916178135.19434.1.nnrp-08.9e984b29_at_news.demon.co.uk>,
> >> > Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> writes
> >> > >You might try putting the /*+ rule */ hint into the query.
> >> > >
> >> > >Jonathan Lewis
> >
> >> > >Luca Minudel wrote
> >> > >Data Dictionary poor performance
> >> > >I'm having poor performance when querying Oracle Data Dictionary table,
> >> > >especially about crowd schemas.
> >> > Or analyzing the tables (see under administration utilities)
> >> > --
> >> > Diane
> Sorry but I just had Oracle support telling me to run analyze on the
> tables today - I am running 2.1.1 and it uses the cost based optimizer.
> Oracle support has told me to reanalyze every time I do a reverse
> engineer or a lot of updates to the tables. I assume they know what
> they're talking about.
> --
> Diane
>
Aaaaargh! It's not data dictionary, it's Designer 2K! Data dictionary is
a part of Oracle RDBMS in which the descriptions of all your database objects
are stored. You should be refering to repository, not dictionary. You can
analyze repository as many times as it pleases you, but don't ever analyze
the dictionary!
Mladen Gogala
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 15 1999 - 16:14:07 CST
