RE: Public Synonyms & Performance

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Sat, 02 Jun 2001 00:29:37 -0700
Message-ID: <F001.0031915A.20010602002528@fatcity.com>

Synonyms have a sustantal impact on performance. Public synonyms are by far greater impact on performance than private ones. The use of synonyms can prove to have a considerable negative impact on cpu time used during parse phase of queries. It can also prove to negatively impact aging of sql statements in the libary cache.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 6/1/01 8:35 PM

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: p_rodri99_at_yahoo.es

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: ListGuru_at_fatcity.com (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  INET: cspence_at_FuelSpot.com

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: ListGuru_at_fatcity.com (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).

Received on Sat Jun 02 2001 - 02:29:37 CDT