Re: what could cause my oracle sequence nextval jump?

From: Dan Norris <>
Date: Fri, 10 Oct 2008 16:25:23 -0500
Message-ID: <>


I'd recommend the webcast as well since Joel also uses a number of live
demos to drive home the points. However, if you'd rather just thumb
through his slides, they're available at
which is in the documents repository on the RAC SIG website.

Dan Norris
RAC SIG President

P.S. Thanks, Edgar, for the reference to the RAC SIG!

Edgar Chupit wrote:
Hi Guang,

You can also take a look at very interesting recorder webseminar
"Managing sequences in a RAC environment" by Joel Goodman at oracle
sig webpage:

On slide 11, he explains usual cases when gaps can occur and also, as
one of the measures, suggests to use dbms_shared_pool.keep to lock
sequence in shared pool.

This webinar explains very thoroughly all main details of sequences
and other techniques of generating sequence numbers. Definitely worth
watching this webinar, even if you think you know enough about

On Fri, Oct 3, 2008 at 5:26 PM, Guang Mei <> wrote:
I have a situation that I can not explain. I have serveral sequences that I set chche size to

Best regards,
Edgar Chupit

-- Received on Fri Oct 10 2008 - 16:25:23 CDT

Original text of this message