Re: what could cause my oracle sequence nextval jump?
- From: "Edgar Chupit" <chupit@xxxxxxxxx>
- To: guangmei@xxxxxxxxx
- Date: Tue, 7 Oct 2008 21:37:57 +0200
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
