Sequence cache parameter

From: Doug Smith <doug.smith_at_fmr.com>
Date: Wed, 28 Jul 1999 08:42:46 -0600
Message-ID: <zAEn3.83$5b2.88@news-srv1.fmr.com>

Greetings,

I work with an application that uses sequences numbers to generate primary key values for the tables in the database.

Recently, the DBA I work with told me that using the default cache parameter on the sequences was evil, and that we should use 20 instead of the default.

When I asked "why 20?", I was informed that he was the DBA, and I should not question his judgement.

My question is what criteria is used to size the sequence cache parameter, and how do we measure the effects of changing the parameter? Also, what are the issues/tradeoffs with changing the cache parameter.

Note that when profiling our app, the code that accesses the sequence numbers does not register as taking a significant amount of time.

Thanks

--Doug Received on Wed Jul 28 1999 - 09:42:46 CDT