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

Flash Gordon wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Flash Gordon wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Flash Gordon wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Flash Gordon wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

"Flash Gordon" <spam (AT) flash-gordon (DOT) me.uk> wrote

will cache the next N values.
Jim

"Flash Gordon" <spam (AT) flash-gordon (DOT) me.uk> wrote

will cache the next N values.
Jim

"Flash Gordon" <spam (AT) flash-gordon (DOT) me.uk> wrote

will cache the next N values.
Jim

"Flash Gordon" <spam (AT) flash-gordon (DOT) me.uk> wrote

will cache the next N values.
Jim

On Mar 5, 6:36*am, Flash Gordon <s... (AT) flash-gordon (DOT) me.uk> wrote:
What do you mean by jumping? You mean there are gaps? There will
always be gaps when using a sequence. I don't know how you managed to
not have gaps using 9. If gaps are not acceptable then you can't use
sequences.