Niall, 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [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). __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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).