X-FeedAbuse: http://nntpfeed.proxad.net/abuse.pl feeded by 88.191.65.235 Path: text.usenetserver.com!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!nntpfeed.proxad.net!news.side3.eu!zen.net.uk!dedekind.zen.co.uk!news-peer-lilac.gradwell.net!not-for-mail Date: Wed, 05 Mar 2008 20:55:24 +0000 From: Flash Gordon User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: Sequence Numbers Jumping References: <88d3b9c2-c17a-46ab-8e16-c00bab119a6b@p73g2000hsd.googlegroups.com> <6384m2F26kco3U2@mid.individual.net> In-Reply-To: <6384m2F26kco3U2@mid.individual.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: X-Leafnode-NNTP-Posting-Host: 83.216.95.193 Lines: 37 NNTP-Posting-Host: 88.208.220.85 X-Trace: 1204750862 news.gradwell.net 514 spamtrap/88.208.220.85:34732 X-Complaints-To: news-abuse@gradwell.net Xref: usenetserver.com comp.databases.oracle.misc:252027 X-Received-Date: Wed, 05 Mar 2008 16:01:03 EST (text.usenetserver.com) Robert Klemme wrote: > On 05.03.2008 16:13, Ken Denny wrote: >> On Mar 5, 6:36 am, Flash Gordon wrote: >> What do you mean by jumping? You mean there are gaps? Yes. >> 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