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: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 21 Apr 2006 18:09:59 +0300
Message-ID: <6e49b6d00604210809h7fb22903m@mail.gmail.com> 





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_at_bossmedia.se>:


> 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


Received on Fri Apr 21 2006 - 10:09:59 CDT












Original text of this message













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