Re: Sequence Numbers Jumping

From: Ken Denny <>
Date: Wed, 5 Mar 2008 07:13:20 -0800 (PST)
Message-ID: <>

On Mar 5, 6:36 am, Flash Gordon <> wrote:
> We are migrating an application from Oracle 9 to Oracle 10. The
> application uses several sequence objects for user visible sequences.
> For some reason on Oracle 10 the sequences are jumping. I've checked
> that the sequences are defined as ordered and tried disabling the
> caching (a desperation measure as I don't believe it could be that).
> Any suggestions as to what could be causing this in Oracle 10 when it
> did not occur in Oracle 9? Any suggestions as to how to investigate this
> as I am new to Oracle?
> --
> Flash Gordon

What do you mean by jumping? You mean there are gaps? There will always be gaps when using a sequence. I don't know how you managed to not have gaps using 9. If gaps are not acceptable then you can't use sequences. Received on Wed Mar 05 2008 - 09:13:20 CST

Original text of this message