Re: index contention in RAC
- From: johan Eriksson <johan.eriksson@xxxxxxxxxxxx>
- To: Gints Plivna <gints.plivna@xxxxxxxxx>
- Date: Fri, 21 Apr 2006 17:26:53 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
