Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Internal lock
hi,
it does help for loads but it also reduces contention on the data dictionary tables.
"Ofer" <oferr_at_realcommerce.co.il> wrote in message news:<br6lk8$57s$1_at_news2.netvision.net.il>...
> 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 - 09:40:24 CST