Re: Sequence nextval problem

I only this because I saw a similar post a couple of days ago and it resolved a query I had.

To ensure sequence values are allocated uniquely, Oracle caches a nunumber of values and allocates
them as reuired by session. If , however a session should rollback, or crash then those sequence
values are never used, so it appears as though some values have been skipped.

hope this makes sense.

Neil.

Vincent Croquette wrote in message <7c37rq$v3q$1_at_minus.oleane.net>...
>When I select the nextval of a sequence, I sometimes get the previous value
>+ the sequence cache size (def 20)
>
>Ex : Sequence.Nextval => 1
>Sequence.Nextval => 2
>Sequence.Nextval => 22 !!!!
>
>Thanks in advance to anyone could help
>
>
Received on Tue Mar 09 1999 - 07:44:30 CST