RE: Determine sequence cache size in RAC

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: