Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sequence #'s skipping
Steve Lehrfeld <DREG_at_hutman.com> wrote in article
<3495B1B3.4D3A6D6F_at_hutman.com>...
> we found that Oracle 7 skips sequence #'s after it has been reset. It
> always rounds to the nearest twenty, i.e. 10001, 10002, <reset>, 10020,
> 10021, 10022, <reset>, 10040, etc.
>
> Does anyone know why it does this and how to prevent it?
>
> -steve
>
>
Steve
to increase performance, Oracle caches sequence numbers in the SGA. By default, the cache size is 20 numbers, which is why following a reset you lose the unused numbers in the cached set and restart at the next 20 numbers.
I believe that it is possible to force Oracle to always check the sequence for a new number, without using a cache - check out the ORDERED parameter to create sequence
Regards
John Roberts Received on Mon Dec 15 1997 - 00:00:00 CST