 | |
Slow data dictionary query from all_synonyms fixsyn script
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Slow data dictionary query from all_synonyms fixsyn script -
04-04-2008
, 01:11 AM
|
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? |
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?
Quote:
|
Shakespeare |
#22
| |||
| |||
|
|
On Sat, 29 Mar 2008 13:18:41 +0100, "Shakespeare" <whatsin (AT) xs4all (DOT) nl 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? Shakespeare Kirmo Uusitalo |
understand this. Coffee at client sites is horrible most of the time.
Shakespeare
#23
| |||
| |||
|
|
On Sat, 29 Mar 2008 13:18:41 +0100, "Shakespeare" <whatsin (AT) xs4all (DOT) nl 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? Shakespeare Kirmo Uusitalo |
understand this. Coffee at client sites is horrible most of the time.
Shakespeare
#24
| |||
| |||
|
|
On Sat, 29 Mar 2008 13:18:41 +0100, "Shakespeare" <whatsin (AT) xs4all (DOT) nl 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? Shakespeare Kirmo Uusitalo |
understand this. Coffee at client sites is horrible most of the time.
Shakespeare
#25
| |||
| |||
|
|
On Sat, 29 Mar 2008 13:18:41 +0100, "Shakespeare" <whatsin (AT) xs4all (DOT) nl 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? Shakespeare Kirmo Uusitalo |
understand this. Coffee at client sites is horrible most of the time.
Shakespeare
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.