Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Internal lock
that usually helps for loads... I have latch contentions...
"Doron" <doron_almog_at_msn.com> wrote in message
news:995517bc.0312090931.7c45b3a2_at_posting.google.com...
> 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 Wed Dec 10 2003 - 02:30:38 CST