Re: Catalog access taking 10 seconds or more

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 03 Apr 2006 08:34:22 GMT
Message-ID: <1144053255.774256@proxy.dienste.wien.at>

J Huntley Palmer <jh_at_dontspam.spam> wrote:
> I am getting this request from an oracle ODBC driver attached to some PC
> based development tools. MS Access is one of them. Regardless, when
> there is catalog information needed this statement gets called and takes
> 10 seconds to resolve on a database that otherwise is quick and
> efficient for regular user data selects and updates.
>
> I am using Release 10.2.0.1.0 on Solaris9 SPARC.
>
> Any ODBC configs to make?

What does the explain plan of this statement say?

Yours,
Laurenz Albe Received on Mon Apr 03 2006 - 03:34:22 CDT