Re: index contention in RAC
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: johan.eriksson@xxxxxxxxxxxx
- Date: Fri, 21 Apr 2006 18:09:59 +0300
How much value you have for sequence cache?
Rather often default 20 is too low. Try at least thousands.
Gints
2006/4/21, johan Eriksson <johan.eriksson@xxxxxxxxxxxx>:
> Hi
>
> we have a table that looks like this:
>
> CREATE table t (
> n1 NUMBER NOT NULL,
> n2 NUMBER NOT NULL,
<skipped>
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: index contention in RAC
- From: johan Eriksson
- References:
- index contention in RAC
- From: johan Eriksson
Other related posts:
- » index contention in RAC
- » Re: index contention in RAC
- » Re: index contention in RAC
- » RE: index contention in RAC
- » RE: index contention in RAC
- » RE: index contention in RAC
- » Re: index contention in RAC
- » RE: index contention in RAC
- » Re: index contention in RAC
- » RE: index contention in RAC
- » RE: index contention in RAC
- » RE: index contention in RAC
- » RE: index contention in RAC
- » Re: index contention in RAC
- » Re: index contention in RAC
- » RE: index contention in RAC
- » RE: index contention in RAC
- Re: index contention in RAC
- From: johan Eriksson
- index contention in RAC
- From: johan Eriksson