Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Gaps in Sequence
Still no guarantees on completely uninterrupted sequences, however you slice
it.
Regards
HJR
"Steven" <steven.pannell_at_gmx.net> wrote in message
news:aemdp0$87mdt$1_at_ID-82797.news.dfncis.de...
> 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 Tue Jun 18 2002 - 03:07:26 CDT