Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sequence #'s skipping

Re: sequence #'s skipping

From: John Roberts <jrobert1_at_netcomuk.co.uk>
Date: 1997/12/15
Message-ID: <01bd09ac$ec7530d0$88e52ac2@nsl23ejohn>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US