"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 Tue Dec 09 2003 - 07:22:01 CST
