Re: Data Dictionary poor performance

From: Luca Minudel <luca.minudel_at_nline.it>
Date: 21 Jan 1999 18:49:12 GMT
Message-ID: <01be456e$3eeea960$0e9e15c2@w95luca>

I made some tracing (alter session set sql_trace =true ...) but I was = unable to do EXPLAIN PLAIN to query against Data Dictionary tables. I'm not sure it's possible.

Isn't it?

 Luca Minudel               Consulente Informatico
 e-mail                      luca.minudel_at_nline.it
 WWW                                     Home Page

http://www.geocities.com/SiliconValley/Vista/4041

Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> scritto nell'articolo = <916778048.13995.0.nnrp-05.9e984b29_at_news.demon.co.uk>...
> Have you tried running it with AUTOTRACE on so that you can see
> what it is doing and what it actually costs ?
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>
>
> Luca Minudel wrote in message <01be432f$05578be0$039e15c2_at_w95luca>...
> I've tryed to with bigger block size, buffer cache, shared_pool, etc. =
but
> performances of query on Data Dictionary tables are still poor.
> A query that need 0.05 sec. to execute now take 0.5 sec. .
> The only difference is the number of tables in the Db.
> Now I've a schema have 4 hundred tables and the whole database have =
3000
> tables.
>
> Any Idea?
>
>
>
>
>
Received on Thu Jan 21 1999 - 12:49:12 CST