Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Internal lock
you probably need to migrate to locally managed TS.
"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
Received on Tue Dec 09 2003 - 11:31:58 CST