Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: index contention in RAC

Re: index contention in RAC

From: johan Eriksson <johan.eriksson_at_bossmedia.se>
Date: Fri, 21 Apr 2006 17:26:53 +0200
Message-Id: <1145633213.24423.75.camel@erijoh.ad.bossmedia.se>


Hi

I did have default 20 and incresed it to 2000. The select nextval dropped considerable to almost nothing.
The inserts now take 98% of the load and the gc buffer busy is 82% of this.
The throughput increased marginally by this.

On Fri, 2006-04-21 at 18:09 +0300, Gints Plivna wrote:
> How much value you have for sequence cache?
> Rather often default 20 is too low. Try at least thousands.
>
> Gints

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 21 2006 - 10:26:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US