Re: Sequence Skipping
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 13 Jun 2012 16:35:12 -0400
Message-ID: <CAGurbTPc0yQwpiUU0RBHHr41DLHzt3p60gtPpbTHLXjyVR_Gqw_at_mail.gmail.com>
I am thinking this is due to MERGE statement ... it probably fetches the sequence irrespective of update or insert. You can either change merge to a manual method, or move procedure_key population to on insert trigger. Raj
Date: Wed, 13 Jun 2012 16:35:12 -0400
Message-ID: <CAGurbTPc0yQwpiUU0RBHHr41DLHzt3p60gtPpbTHLXjyVR_Gqw_at_mail.gmail.com>
I am thinking this is due to MERGE statement ... it probably fetches the sequence irrespective of update or insert. You can either change merge to a manual method, or move procedure_key population to on insert trigger. Raj
On Wed, Jun 13, 2012 at 3:32 PM, Kenneth Naim <kennethnaim_at_gmail.com> wrote:
> Every night the process runs the sequence (seq_procedure_key) gets
> incremented by approximetly 57,000 values even though only 4-37 rows are
> added. There are about 57,000 in the procedures table, BTW the cache on
> the sequence is 50.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 13 2012 - 15:35:12 CDT