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

Raj

On 8/23/06, Powell, Mark D <mark.powell_at_eds.com> 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.
>
>

--
http://www.freelists.org/webpage/oracle-l