Re: Caching in Sequence generators

If I remember correctly, I think the only good reason for using nocahce is when using parallel server. This will force the sequence number to be ordered across multiple instances. I did see some test papers on this several years ago. In our tests we were logging updates from several tables and using a sequence number to order the transactions. Because we were using parallel server we needed to set the cache to zero. If I remember correctly this slowed the process down by 20 to 30%.

"D. Oakley" wrote:

> (Running Oracle 7.3 on Unix)
>
> Hi,
>
> I was having a problem with a sequence generator that i was using in that it
> seemed to be skipping numbers in blocks of 20. I presumed this was being
> caused by the default cache setting of 20. Firstly, is this a safe
> presumtion?
>
> Secondly, what effect will there be on performance of the sequence generator
> if I set the caching to NOCACHE?
>
> Thanks.
Received on Wed Apr 21 1999 - 04:44:30 CDT