Rac sequence

create sequence seq1  
minvalue 1  
maxvalue 99999999999999999999  
start with 1  
increment by 1  
cache 1000; 

 select seq1.nextval  from dual; 

 SQL> select * from user_sequences;

SEQUENCE_NAME			MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
SEQ1					1 1.0000E+20		1 N N	    1000	   1

SQL>  select seq1.nextval  from dual;

   NEXTVAL
----------
	 1

节点1:
SQL> create sequence seq1  
minvalue 1  
maxvalue 99999999999999999999  
start with 1  
increment by 1  
cache 1000;   2    3    4    5    6  

Sequence created.


SQL>  select seq1.nextval  from dual; 

   NEXTVAL
----------
	 1


SQL> select * from user_sequences;

SEQUENCE_NAME			MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
ERRORMESSAGE_SEQUENCE			1 1.0000E+20		1 Y N	      20	 100
MESSAGEIN_SEQUENCE			1 1.0000E+20		1 Y N	      20     1011107
MESSAGEOUT_SEQUENCE			1 1.0000E+20		1 Y N	      20      993634
SECURITY_MENUS_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SECURITY_PERMISSIONS_SEQUENCE		1 1.0000E+20		1 Y N	      20	 100
SECURITY_RESOURCES_SEQUENCE		1 1.0000E+20		1 Y N	      20	 100
SECURITY_ROLES_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SECURITY_USERS_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SEQ1					1 1.0000E+20		1 N N	    1000	1001

9 rows selected.

SQL> select seq1.nextval  from dual; 

   NEXTVAL
----------
	 2

SQL> select * from user_sequences;

SEQUENCE_NAME			MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
ERRORMESSAGE_SEQUENCE			1 1.0000E+20		1 Y N	      20	 100
MESSAGEIN_SEQUENCE			1 1.0000E+20		1 Y N	      20     1011107
MESSAGEOUT_SEQUENCE			1 1.0000E+20		1 Y N	      20      993634
SECURITY_MENUS_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SECURITY_PERMISSIONS_SEQUENCE		1 1.0000E+20		1 Y N	      20	 100
SECURITY_RESOURCES_SEQUENCE		1 1.0000E+20		1 Y N	      20	 100
SECURITY_ROLES_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SECURITY_USERS_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SEQ1					1 1.0000E+20		1 N N	    1000	1001

9 rows selected.


节点2：

SQL> set linesize 200
SQL> select * from user_sequences;

SEQUENCE_NAME			MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
ERRORMESSAGE_SEQUENCE			1 1.0000E+20		1 Y N	      20	 100
MESSAGEIN_SEQUENCE			1 1.0000E+20		1 Y N	      20     1011107
MESSAGEOUT_SEQUENCE			1 1.0000E+20		1 Y N	      20      993634
SECURITY_MENUS_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SECURITY_PERMISSIONS_SEQUENCE		1 1.0000E+20		1 Y N	      20	 100
SECURITY_RESOURCES_SEQUENCE		1 1.0000E+20		1 Y N	      20	 100
SECURITY_ROLES_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SECURITY_USERS_SEQUENCE 		1 1.0000E+20		1 Y N	      20	 100
SEQ1					1 1.0000E+20		1 N N	    1000	1001

9 rows selected.

SQL>  select seq1.nextval  from dual; 

   NEXTVAL
----------
      1001

节点2会从1001开始