Re: Sequence Numbers Jumping

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 10.1.0.2 and 10.2.0.3 but if it isn't 10.2.0.3 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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org