Re: all_synonyms: performance issues

oracle needs to run this during object resulution phase.

Objects are always resolved in this order
1. Current schema
2. private synonyms
3. public synonyms


On 8/23/06, Powell, Mark D <mark.powell@xxxxxxx> wrote:

As far as details of why Oracle runs this I do not know of any reference
other than the general information given in the Performance manual where
Oracle discusses the steps followed in parsing SQL.

Other related posts: