Re: Corporate Wide Public Synonyms

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Mon, 14 Feb 2005 11:57:21 GMT
Message-ID: <Bm0Qd.160876$K7.121229@news-server.bigpond.net.au>

<yong321_at_yahoo.com> wrote in message
news:1108131913.154821.319710_at_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.
>

Hi Yong

In varying degrees, the latch contention was on library cache latch, the shared pool latch and the row cache objects latch. One other point I didn't mention was the CPU consumption was also reduced to a significant degree.

Cheers

Richard Received on Mon Feb 14 2005 - 05:57:21 CST