sequences with cache option

We are noticing some erratic sequence jumps with our Orcacle 7.3.2 server. The sequence was created with the following statement:

CREATE SEQUENCE customer_id

        INCREMENT BY 1
        START WITH    50
        MAXVALUE      99999999
        ORDER   NOCYCLE;

We left out the cache option because Oracle will use a default of 20. We are noticing that the sequence will jump by a maximum increment of 20 sometimes, but definitely not every time. The amount of the increment does not seem to be constant. We've checked our code, GUI, and create scripts and have been able to rule them out as the possible culprit. We are starting to believe that this may have something to do with the cache option, but have been unable to find any documentation that might explain this.

Any help would be appreciated.

Ron Chapman
ronc_at_jagman.com Received on Tue Aug 19 1997 - 00:00:00 CDT