I have a sequence that is not creating consistant sequence numbers. Parameters are:
1) Increment by: 2
2) Cache: 20
3) Min Value: 1
4) Max Value: 999999999
5) Recycle and Guarentee Order are not checked
6) Oracle 8.1.7
Sequences will generate normally for a short period of time (minutes) and then jump by 40 (last_number in dba_sequences increases by 40 after the last successful increment by 2). If I decrease the cache to 10, then dba_sequences.last_number will jump by 20. All I want is for the sequence to consistantly increment by 2. What am I doing wrong?