Re: multiple Sequences

Not quiet right.
For each sequence, which has a cache value defined, oracle pre-allocates the specified number of sequencevalues.
 The cache is shared by all Oracle sessions.During a shutdown/startup cycle of the DB the
unused values in the cache are lost. So every time your DB is restarted you loose some values.

hth
eugen

Martin Meister wrote:

> Got It:
>
> Oracle creates for every session an cache of sequences, by default 20.
> If you don'n use them they are lost for the next session.
>
> Martin Meister wrote:
> >
> > Hi,
> >
> > i've builded a DB with several sequences, incrementig by 1.
> > When i insert a value in a table, i count the sequence on up.
> > When I work on other tables with other sequences, the first sequence
> > counts from a higher number as it should be.
> >
> > Why??
> >
> > Counts Oracle intern with one table?
> >
> > any Ideas are welcome
> >
> > martin
> >
> > --
> > Martin Meister
> > webactive GMBH
> > meister_at_web-active.com
> > www.web-active.com
>
> --
> Martin Meister
> webactive GMBH
> meister_at_web-active.com
> www.web-active.com
Received on Tue Apr 18 2000 - 00:00:00 CDT