Re: Slow data dictionary query from all_synonyms fixsyn script
Date: Fri, 4 Apr 2008 10:55:23 +0200
"Kirmo Uusitalo" <not_at_exists.com.invalid> schreef in bericht
> On Sat, 29 Mar 2008 13:18:41 +0100, "Shakespeare" <whatsin_at_xs4all.nl>
>>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