Re: sequences with cache option

Ron,

   I have ran into the same problem where I left the default for the cache. When my program uses the sequence, the next sequence then starts at 20+ eventhough the nextval is 1. Cheesy.

  What I did was explicitly specified then NOCACHE option when creating the sequence. I also have NOCYCLE NOORDER.

Hope this helps.

Thomas

In article <33FA1164.9BDA8F63_at_jagman.com>, Ron Chapman <ronc_at_jagman.com> writes:

>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 Thu Aug 21 1997 - 00:00:00 CDT