Re: all_synonyms: performance issues

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: mark.powell@xxxxxxx
  • Date: Wed, 23 Aug 2006 12:26:39 -0400

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@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: