Re: Corporate Wide Public Synonyms

From: <yong321_at_yahoo.com>
Date: 11 Feb 2005 06:25:13 -0800
Message-ID: <1108131913.154821.319710@g14g2000cwa.googlegroups.com>

Richard Foote wrote:
> <linuxgeek_00_at_yahoo.com> wrote in message
> news:1108068838.968042.219230_at_f14g2000cwb.googlegroups.com...
>
> At a site I work, they previously had a couple of thousand or so
users
> accessing everything through public synonyms. Latch contention was a
> significant performance bottleneck.
>
> By using setting the appropriate current_schema via a logon trigger,
the
> associated latch contention issues pretty well vanished.

Hi, Richard,

Do you remember what latch the contention was on? It must be library cache latch I guess. Any other one? Thanks.

Yong Huang
yong321ATyahoo.com Received on Fri Feb 11 2005 - 08:25:13 CST