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: Gaps in Sequence

Re: Gaps in Sequence

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 17 Jun 2002 14:55:51 +0100
Message-ID: <HTlP8.1780$vB.11899@news.indigo.ie>


The other poster got in first !

Do NOT use sequences for continuity. Be prepared for gaps. I think Tom Kyte deals with this prob. once every 8 weeks or so over on asktom.oracle.com

However it begs the question though can a nextval select be audited from the sequence (i.e. just the sequence itself ?

"Steven" <steven.pannell_at_gmx.net> wrote in message news:aek775$6rms7$1_at_ID-82797.news.dfncis.de...
> Hi,
>
> I have sequences on all our tables in a oracle 8.1.7. database, Solaris
2.7.
> However, these sequences are not always in sequence. Sometimes there is a
> gap of 20 numbers, but also there are lots of random gaps between 2-20
> numbers. I have not stopped the database or performed any rollback and
the
> entries on the tables are entered through an application so we can be sure
> of this. This happens on all my tables. All tables are accessed through
> the same user. The default cache is 20 numbers but why the gap where there
> is no stopping of the database or rollback??
>
> Any help appreciated.
>
> Steve.
>
>
>
Received on Mon Jun 17 2002 - 08:55:51 CDT

Original text of this message

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