Sequence not in order in RAC ?
877720Dec 10 2012 — edited Dec 10 2012I created a sequence in a 2-nodes RAC:
create sequence SEQ_STEP
minvalue 1
maxvalue 9999999999999999999999999999
start with 30000000
increment by 1
cache 20
order;
and I put a trigger in my table, before insert I will use SEQ_STEP.nextval to set as primary key.
but when I start my application for some time, I saw a lot of sequence generated not in order like below:
30324126 2012/12/1 8:13:16
30324128 2012/12/1 8:13:18 <=this record is inserted before the next one, but it got a bigger sequence value.
30324127 2012/12/1 8:13:23
Why?