Re: Synonyms

  • From: Grzegorz Goryszewski <grzegorzof@xxxxxxxxxx>
  • To: jd@xxxxxxxxxxxxxxxxx
  • Date: Wed, 01 Dec 2010 09:34:23 +0100

Despite of all goods synonyms got also drawbacks:
Let me quote Steve Adams on this:
Public synonyms should be entirely avoided in high concurrency environments. The memory wasted is proportional to the number of public synonyms in use, times the number of users. The performance cost is mainly in terms of increased latching in the shared pool and library cache.
This script shows the number of users for each public synonym in use.
This indicates whether there is any risk of potential performance problems due to public synonyms

More details here:  look for



Duzi chlopcy lubia wampiry i krew.


Other related posts: