Re: Gaps in Sequence

Thanks to all that responded.

After digging around at metalink I found out that Oracle stored the sequences in the SGA and thus after a period of non-use they get kicked out of the SGA and the result is you lose 20 or so numbers that have not been used. The solution can be to pin the sequence in the SGA, but for seqeunces that are not used very often just use NOCACHE.

"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 - 23:43:13 CDT