Jun 172013
 
select a_sequence.nextval,
       may_not_come_out_in_order
from   rac_databases;

   NEXTVAL MAY_NOT_COME_OUT_IN_ORDER
---------- -------------------------
         1                         Y 

conn chris@rac_node2

select a_sequence.nextval,
       may_not_come_out_in_order
from   rac_databases;

   NEXTVAL MAY_NOT_COME_OUT_IN_ORDER
---------- -------------------------
        21                         Y 

conn chris@rac_node1

select a_sequence.nextval,
       may_not_come_out_in_order
from   rac_databases;

   NEXTVAL MAY_NOT_COME_OUT_IN_ORDER
---------- -------------------------
         2                         Y 

From time-to-time code is written to process items greater than or equal to the last value in a 
table based on a sequence (usually the primary key). Because sequence values are cached on each 
instance rather than cluster-wide, be prepared for this to break if you move to a RAC environment!

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)