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?
Denis
Other related posts:
