Re: Slow response from Data Dictionary?

Hi,

Another point we just bumped into because we have some performance problems also. When we checked the SGA we saw a lot of SQL-statements parsed again with each execution. The SGA and especially the sql-area was full

and it swapped a lot of statements out. When we digged into the statement we found quite some without bind-variables although we checked this about a year ago it seemed that was not enough and new statements were wrong also.

Jeroen

John Mara wrote:

> We are running a rather large development server (7000 tables over 20
> schemas) and have some pretty slow response times when accessing the DBA_
> tables. This is somewhat understandable given the volume. Are there any
> tuning options to speed things up? I have heard that it is not a good idea
> to ANALYZE the Data Dictionary tables, that they are self maintaining.
>
> We tried an export/import of the entire database to compress extents, and
> surprisingly found that our response times got worse? In particular,
> dropping any objects that have storage allocated has become extremely slow
> (minutes for a table with no data???).
>
> Any suggestions would be appreciated. Thanks.
Received on Thu Jul 23 1998 - 01:21:30 CDT