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 <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).
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: 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).
Received on Fri Jan 09 2004 - 18:59:25 CST