Re: Data Dictionary poor performance

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 19 Jan 1999 20:13:06 -0000
Message-ID: <916778048.13995.0.nnrp-05.9e984b29@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 Tue Jan 19 1999 - 14:13:06 CST