Re: User Sequence Skipping Numbers???

Thank you everyone for your detailed reponses. Rudy, pretty much detailed what I already thought was going on, but since this is my first full-blown Oracle app, I wanted to make sure I was not missing anything.

Our concern about jumping numbers, (which did seem much worse with caching on) was due to the fact that we were double-entering jobs for a month as an emergency fallback, and the old system was putting out job numbers that we were trying to match with the new numbers.

A BIG Part of the problem had to do with my own sloppiness when I did the system switch over. (Not shall we say ideal conditions.) I had left some test records in the detail tables which happened to have the same job numbers as real records that were being inserted in the main table when we went live. So the insert into the main table would work, then it would fail on the insert to the detail table (as it should) and the whole transaction would roll back. However, having said all of that, I am also seeing instances where it appears that the number is jumping for no rhyme or reason. That is why I came to this group to see if I was missing something obvious.

Thanks also for the alternative method around the jumping numbers. ((Max + 1). I think I will need to watch the problem further. (And maybe put a some time of date/info stamp on the db.)

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 Mon Apr 05 1999 - 16:49:46 CDT