Re: index contention in RAC

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