RE: Determine sequence cache size in RAC

  • From: "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx>
  • To: "denis.sun@xxxxxxxxx" <denis.sun@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 2 May 2011 22:14:22 +0000

Values of 1000 to 10000 have worked well for me :)  This was derived from trial 
and error.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Denis
Sent: Wednesday, April 20, 2011 6:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Determine sequence cache size in RAC

Hi, listers,

Is there a rule of thumb that relates sequence cache size to insert rate and 
number of instances? Anyone can share what the cache size is for your RAC's 
insert-intensive tables?


Other related posts: