Re: User Sequence Skipping Numbers???

I am (really) interested as to why you are concerned with gaps. I can understand reasons in a paper based system because a missing number might mean a missing document. However, I'm not so sure why it's so important in computer stored information.

If you don't won't gaps then you have to use an oracle table which contains a single row/column. Each transaction increments the value and any uncommitted transactions revert the number. However, it might introduce locking problems because the next transaction must wait until the previous work has been committed or rolled back. One reason why Oracle introduced sequence numbers.

Kathy Graham wrote:

> Hi Folks;
> I have set up a new production application that uses user sequences
> for the work/job numbers. The groups that use these need to use all of
> the job numbers and are very concerned when the job numbers jump/skip
> for no apparent reason. (As I am as well.) I can look at the user
> sequences and see that I have the order flag set to Y and I have nocache
> set as well. (This seems to have lowered the number of numbers skipped
> say from 20 to 2 or 3, but it is still a problem.) I am not sure what
> else to fix or look at. I am running on Oracle 7.3.2.3.0. Any ideas?
> Thanks in advance....
>
> Kathy Graham
Received on Thu Apr 01 1999 - 03:14:17 CST