Re: what could cause my oracle sequence nextval jump?

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: http://www.oracleracsig.org/pls/apex/f?p=105:206

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 <guangmei_at_yahoo.com> wrote:
> I have a situation that I can not explain. I have serveral sequences that I set chche size to

--
Best regards,
Edgar Chupit
callto://edgar.chupit
--
http://www.freelists.org/webpage/oracle-l