Re: Internal lock

From: Ofer <oferr_at_realcommerce.co.il>
Date: Wed, 10 Dec 2003 10:29:24 +0200
Message-ID: <br6lhv$56m$1@news2.netvision.net.il>

It seems I have some library cache contentions... lots of waits.

I'm thinking maybe to increase _spin_count parameter

"Chris" <cs123._no_spam__at_telstra.com> wrote in message news:Z%jBb.46111$aT.41989_at_news-server.bigpond.net.au...
>
> "Ofer" <oferr_at_realcommerce.co.il> wrote in message
> news:br43k9$8gi$1_at_news2.netvision.net.il...
> > Hi all,
> >
> > I have a problem with Oracle internal locks increasing daily.
> > I've raised the db_block_lru_latches parameter up to 4 times my CPU
count,
> > it helped for a while, but now I have high internal locks again.
> >
> > Environment: Oracle 8.1.6; my main application does not allow use of
bind
> > variables; I run a news internet site, so usually most of the surfers
> browse
> > the same article...
> >
> > Does anyone have an idea for a way to reduce internal locks?
> >
> > I monitor my DB with SQL PRECISE application
> >
> >
> How do you know it's the LRU latches causing the problem.
> Have you run statspack and what are the results?
> BTW, can you upgrade to 8.1.7.4?
>
>
>
Received on Wed Dec 10 2003 - 02:29:24 CST