RE: public vs. private synonym internals

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@xxxxxxxxxxxxx on behalf of ryan.gaffuri@xxxxxxx
Sent:   Thu 5/27/2004 3:22 PM
To:     oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------



-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: