Thanks, Raj - another lister had pointed out to me that the object should be
fully qualified, and it is. If the object is qualified and in the current
schema, steps 2 and 3 should be skipped, correct?
On 8/23/06, rjamya <rjamya_at_gmail.com> wrote:
>
> 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.
> >
> >
>
>
--
Charles Schultz
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 23 2006 - 11:33:20 CDT
