Re: Data Dictionary poor performance

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Thu, 14 Jan 1999 09:37:10 -0600
Message-ID: <369E0F26.307490C0@csgsystems.com>

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
> >Yet another Oracle-related web site: www.jlcomp.demon.co.uk
> >
> >
> >
> >Luca Minudel wrote in message <01be3e63$c94cf1a0$029e15c2_at_w95luca>...
> >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:37:10 CST