Re: Synonyms

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: http://www.ixora.com.au/scripts/library.htm  look for


   public_synonym_users.sql

Regards.
Greg



----------------------------------------------------------------------
Duzi chlopcy lubia wampiry i krew.
http://linkint.pl/f2718

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


Other related posts: