Re: Internal lock

Ofer wrote:

> 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

8.1.6 was not exactly one of Oracle's better product releases. It also hasn't been supported for quite a few years. I would suggest upgrading to 8.1.7.4 immediately though 9.2.0.4 would be better.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)