Re: Why Sequence jumps?

From: Tim Romano <tim_at_ot.com>
Date: Mon, 28 Jun 1999 10:10:51 -0400
Message-ID: <3777826B.FC7A0361@ot.com>

In addition to cache issues already discussed in another reply,a transaction when rolled back does not give back any sequence numbers to the sequence(s) for reuse. So you couldn't use a sequence to provide numbers for, say, a check register. Its purpose is simply to guarantee a unique value.
Tim Romano

Wassim wrote:

> Hi,
> I'm using Sequences (as many of you told me to do, for generating a
> primary keys in some tables) Strange phenomenen i've noticed is that in
> some cases counter jumps from 21 to 40 or 11 to 34 ? this is source of
> my sequences :
>
> create sequence mvt_seq
> start with 0
> increment by 1
> nomaxvalue
> minvalue 0
> nocycle
> order (cos order is important for me!)
>
> Is there any problem with this?
> Thanks for help!
>
> Wassim.
> e-mail: net2000_at_francemel.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 28 1999 - 09:10:51 CDT