Re: Data Dictionary poor performance

From: Darryl E Balaski <darryl_e_balaski_at_groton.pfizer.com>
Date: Thu, 14 Jan 1999 10:50:42 -0500
Message-ID: <369E1252.2309@groton.pfizer.com>

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
Received on Thu Jan 14 1999 - 09:50:42 CST