RE: Determine sequence cache size in RAC

From: CRISLER, JON A (ATTCORP) <"CRISLER,>
Date: Mon, 2 May 2011 22:14:22 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3043170_at_MISOUT7MSGUSR9D.ITServices.sbc.com>

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Denis Sent: Wednesday, April 20, 2011 6:38 PM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 02 2011 - 17:14:22 CDT