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: 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
