Re: Sequence Numbers Jumping

From: Flash Gordon <>
Date: Wed, 05 Mar 2008 20:55:24 +0000
Message-ID: <>

Robert Klemme wrote:
> On 05.03.2008 16:13, Ken Denny wrote:

>> On Mar 5, 6:36 am, Flash Gordon <> wrote:

<snip question about cause of gaps in sequences>

>> 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.

Well, we were not getting anywhere near as many, or so the application people tell me.

>> If gaps are not acceptable then you can't use
>> sequences.

> Adding to that these are the reasons why you can get gaps:
> - caching enabled and sessions close without using all values cached so far
> - rollbacks on TX that inserted sequence values
> - deletions
> Did I miss one?

You missed application bugs :-)

Thank you everyone. It looks like it was the caching causing some of the problems and a bug in application causing most of the rest. I will also pass on your comments to the application people.

Flash Gordon
Received on Wed Mar 05 2008 - 14:55:24 CST

Original text of this message