Re: Gaps in Sequence

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 17 Jun 2002 18:06:55 +0100
Message-ID: <1024333552.27695.0.nnrp-10.9e984b29@news.demon.co.uk>

See the FAQ

http://www.jlcomp.demon.co.uk/faq/ind_faq.html

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            June / July
        Australia      July / August
http://www.jlcomp.demon.co.uk/seminar.html

Steven wrote in message ...


>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 - 12:06:55 CDT