Re: Sequence Numbers Jumping

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

"Flash Gordon" <spam_at_flash-gordon.me.uk> wrote in message news:b6d2a5xm01.ln2_at_news.flash-gordon.me.uk...
> 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

This message: [ Message body ]
Next message: dananrg_at_yahoo.com: "Re: Looping through column values in a record without specifying column names?"
Previous message: DA Morgan: "Re: Looping through column values in a record without specifying column names?"
In reply to: Flash Gordon: "Sequence Numbers Jumping"
Next in thread: Ken Denny: "Re: Sequence Numbers Jumping"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message