Re: what could cause my oracle sequence nextval jump?

From: Edgar Chupit <>
Date: Tue, 7 Oct 2008 21:37:57 +0200
Message-ID: <>

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 sequences.

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 Tue Oct 07 2008 - 14:37:57 CDT

Original text of this message