RE: Suggestions Needed: Latch free - library cache

I think you're right... and as my databases, even those with multiple
applications in them, rarely have more than 20 named users, that's
likely the reason I see no degradation, even on custom apps.

Nice to know it's not just me :)

Rachel

Niall Litchfield <niall.litchfield_at_dial.pipex.com> wrote:
> Hi Rachel> > My understanding of the negative aspects of public synonyms is that> they> kick in as the number of distinct Oracle Users you have increases. My> *experience* is much the same as yours - namely I almost couldn't> care,> however this is predicated on applications tracking users and not> using a> different Oracle account for each user. (typically we have 1-2> accounts per> app). The archetype of application development on Oracle says that> you have> a different oracle account for each user (albeit probably OS> authenticated).> Mind you that same archetype says you can change the sql. I think> that the> drawbacks that steve has in mind don't apply to the majority of 3rd> party> apps.> > Niall > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- > Author: Niall Litchfield> INET: niall.litchfield_at_dial.pipex.com> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> ---------------------------------------------------------------------> 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.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).