Printable View
some of the user complained that the sequence number that was generated from the application was skipped somehow.
Does anyone know why it skipped ??? There was nothing in the log file. the cause and solutions for this problems???
below is the dll of my sequence.
CREATE SEQUENCE blaw
INCREMENT BY 1
START WITH 1000000
MINVALUE 1
MAXVALUE 999999999999999999999999999
NOCYCLE
NOORDER
CACHE 20
/
thanks
You can't rely on there being no gaps. Some system crashes will loose the values in cache. Picking up some NEXVAL's and then Rolling Back the transaction will make a gap too. If you want a heated opinion on this, search on "Ask Tom".
Here's Tom on the subject:
http://asktom.oracle.com/pls/ask/f?p...:530735152441,
Hi,
It is possible that individual sequence numbers will appear to be skipped, because they were generated and used in a transaction that ultimately rolled back.
User may not realize that other users are drawing from the same sequence.
Seelan