Re: Slow data dictionary query from all_synonyms fixsyn script

From: Shakespeare <>
Date: Fri, 4 Apr 2008 10:55:23 +0200
Message-ID: <47f5ecfd$0$14361$>

"Kirmo Uusitalo" <> schreef in bericht
> On Sat, 29 Mar 2008 13:18:41 +0100, "Shakespeare" <>
> wrote:
>>But why would you want it any faster? How many times will you run this
>>query? How often do you create synomyms or grant objects?
> It is part of our application version upgrade script. As there are
> quite a lot of objects, users and synonyms, on a typical client
> install verifying with the fixsyn.sql script that all synonyms are OK
> takes around 20-30 minutes. I would like it to be faster. You don't
> want to drink that much of coffee, don't you? :)
> Kirmo Uusitalo

Sure I do! But if you have to perform this for multiple client sites, I understand this. Coffee at client sites is horrible most of the time.

Shakespeare Received on Fri Apr 04 2008 - 03:55:23 CDT

Original text of this message