Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence cache parameter
tell your DBA that 20 is the default value for cache parameter.
Doug Smith wrote in message ...
>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 - 11:08:39 CDT