You could get more information about this subject in Steve Adams website..Here is the few lines from his site:
" 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.
This script tends to understate the severity of the problem, because it looks for the library cache structures used to represent non-existent objects while resolving public synonyms, and these structures can be freed from the cache very quickly under some circumstances.
"
http://www.ixora.com.au/scripts/library.htm
http://www.ixora.com.au/q+a/0012/05112945.htm
http://www.ixora.com.au/newsletter/2001_05.htm
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
| Pablo ksksksk <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 06/01/01 07:35 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Public Synonyms & Performance |
HI all,
I think someone ask this question before, but I don't
have any mails about this.
What are the performance implications in the use of
PUBLIC synonyms ? (What about private synonyms?)
How does Oracle resolve internally a public synonym
use?
TIA
_______________________________________________________________
Do You Yahoo!?
Yahoo! Messenger: Comunicaci�n instant�nea gratis con tu gente -
http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
