Re: Sequence Numbers Jumping

From: <>
Date: Wed, 05 Mar 2008 12:52:44 GMT
Message-ID: <wIwzj.10650$6R.3195@trnddc04>

"Flash Gordon" <> wrote in message
> We are migrating an application from Oracle 9 to Oracle 10. The
> application uses several sequence objects for user visible sequences. For
> some reason on Oracle 10 the sequences are jumping. I've checked that the
> sequences are defined as ordered and tried disabling the caching (a
> desperation measure as I don't believe it could be that).
> Any suggestions as to what could be causing this in Oracle 10 when it did
> not occur in Oracle 9? Any suggestions as to how to investigate this as I
> am new to Oracle?
> --
> Flash Gordon

If the sequence gets aged out of the sga then when it is referenced again it will cache the next N values.
Jim Received on Wed Mar 05 2008 - 06:52:44 CST

Original text of this message