Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: public vs. private synonym internals

RE: public vs. private synonym internals

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 27 May 2004 18:06:12 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFCF1@bosmail00.bos.il.pqe>


Hmm...the only thing that comes to mind is that public synonyms can have a much larger impact on your library cache, particuarly with lots of concurrent users, due to the negative dependency objects that are maintained when public synonyms are implemented. Other than that (which can be significant), I can't imagine how much differently synonyms would be handled as far as public vs. private goes.

-Mark

-----Original Message-----

From:	oracle-l-bounce_at_freelists.org on behalf of ryan.gaffuri_at_cox.net
Sent:	Thu 5/27/2004 3:22 PM
To:	oracle-l_at_freelists.org
Cc:	
Subject:	public vs. private synonym internals
I was on the phone with oracle support recently. We have ORA-600 errors in production pertaining to public synonyms and our IIS middle tier. Neither we nor Oracle know why. We were able to switch to private synonyms and it works for now.

The oracle support person said there are internal oracle docs on the internals and the differences between them, but can't give it to me. Has anyone written any articles on the topic?



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu May 27 2004 - 17:03:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US