Re: Sequence Numbers Jumping

From: DA Morgan <>
Date: Wed, 05 Mar 2008 04:47:57 -0800
Message-ID: <>

Flash Gordon wrote:
> 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?

I've never seen this behavior and wonder what you mean by Oracle 10 as there is no such version number. I presume you mean some variant on 10g between and but if it isn't start with applying the available patches.

If that doesn't do it then post a test case others can try.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Mar 05 2008 - 06:47:57 CST

Original text of this message