Slow response from Data Dictionary?

Could it be possible that your SGA is very small to house the dictionary? Check with the UNIX admin guys for any excessive swapping, even when there is no 'application' activity. Do you experience the slow performance for all dictionary queries ? Does this only after happen after database startup, for a short time, before attaining a steady state.

Also, check your v$system_event, v$session_wait views for any abnormal waits.

> -----Original Message-----
> From: Jeroen van Sluisdam [SMTP:Jeroen.van.Sluisdam_at_vrijuit.nl]
> Posted At: Thursday, July 23, 1998 1:22 AM
> Posted To: server
> Conversation: Slow response from Data Dictionary?
> Subject: 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 Fri Jul 24 1998 - 09:27:19 CDT